MS SQL tutorial on CONVERT and CAST functions
This is a Microsoft SQL tutorial video demonstrating the use of the CONVERT and CAST functions. These functions change the data types of data, variables and columns.
Complimentary videos:
Data types: • MS SQL covering an introduction to da...
Complimentary SQL:
select '01 Jan 2021', convert(date, '01 Jan 2021')--, convert(date, '41 Jan 2021')
, convert(char(10), '01 Jan 2021', 103), convert(char(10), cast('01 Jan 2021' as date), 103)
, convert(char(10), cast('01 Jan 2021' as date), 3)
, convert(varchar(20), getdate(), 113)
, convert(char(10), getdate(), 103), convert(varchar, getdate(), 108)
, convert(char(10), getdate(), 103) + ' ' + convert(char(5), getdate(), 108)
select convert(varchar, cast(12345.6789 as money), 0)
, convert(varchar, cast(12345.6789 as money), 1)
, convert(varchar, cast(12345.6789 as money), 2)
select distinct pe.FirstName + ' ' + pe.LastName + ' ' + CAST(pv.AverageLeadTime AS VARCHAR(5)), CONVERT(char(10), pe.ModifiedDate, 103)
from Purchasing.ProductVendor pv
inner join Person.BusinessEntityContact be on pv.BusinessEntityID = be.BusinessEntityID
inner join Person.Person pe on be.PersonID = pe.BusinessEntityID