![]() ![]() Good thing there are usually multiple ways to do things in SQL Server. Hi Jeff, thanks for your input on performance with the FORMAT statement. Wednesday, Novem1:54:12 PM - Greg Robidoux 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 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. How SQL Server handles the date format YYYY-MM-DD SQL Date Format examples using SQL FORMAT Function SQL Server Date and Time Functions with Examples
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |