Great solution for converting date to an integer " CONVERT(CHAR(8),112) as 'MyDate' " and this solution is efficient than converting date this way " FORMAT(, 'yyyyMMdd') as 'MyDate' " Wednesday, Janu4:56:06 PM - Zingisa Matwana
SQL CONVERT STRING TO DATE YYYYMMDD ISO
In other words, DATETIME is not standard.Īlso, a tiny observation: if you ever create, say, a computed column that will use CAST for date-time conversion, when you script out the table, you will notice that the script will be created using CONVERT, not CAST.Īs a final note: 'YYYMMDD' and 'YYMMDD' are ISO standard, so they should be used for data retrieval. : Use the time, date, datetime2 and datetimeoffset data types for new work. The different date delimiters and the ability to use different delimited dates as Results: Review the 3 result sets from the queries! Note Note using Year, month, day in the where clause that SQL server will recognize different delimiters: dash, slash, dot or no delimiter as shown above.
SELECT FORMAT(,'yyyy-MM-dd') as 'MyDate_w_Dash',įORMAT(,'yyyy/MM/dd') as 'MyDate_w_Slash',įORMAT(,'yyyy.MM.dd') as 'MyDateTime_w_Dot' Alternative formates that returs Year Month Day mixing Date and Datetime formats using FORMAT: Alternative formats that returns Year Month Day mixing Date and Datetime formats using CONVERT:
0 kommentar(er)
