SQL Date Format Cheat Sheet: Convert Styles Reference
Classified in Mathematics
Written on in 
English with a size of 1.25 MB
SQL Date Format Cheat Sheet
This reference provides a comprehensive list of SQL Server CONVERT styles for formatting date and time values. Use these codes to transform your data into the desired output format.
Common Date and Time Conversion Styles
| Style | Standard | CONVERT Statement | Output |
|---|---|---|---|
| 100 | Default (datetime/smalldatetime) | SELECT CONVERT(VARCHAR(20), GETDATE(), 100) | mon dd yyyy hh:miAM (or PM) |
| 101 | U.S. | SELECT CONVERT(VARCHAR(10), GETDATE(), 101) | mm/dd/yyyy |
| 102 | ANSI | SELECT CONVERT(VARCHAR(10), GETDATE(), 102) | yyyy.mm.dd |
| 103 | British/French | SELECT CONVERT(VARCHAR(10), GETDATE(), 103) | dd/mm/yyyy |
| 104 | German | SELECT CONVERT(VARCHAR(10), GETDATE(), 104) | dd.mm.yyyy |
| 105 | Italian | SELECT CONVERT(VARCHAR(10), GETDATE(), 105) | dd-mm-yyyy |
| 106 | - | SELECT CONVERT(VARCHAR(11), GETDATE(), 106) | dd mon yyyy |
| 107 | - | SELECT CONVERT(VARCHAR(12), GETDATE(), 107) | Mon dd, yyyy |
| 108 | - | SELECT CONVERT(VARCHAR(8), GETDATE(), 108) | hh:mi:ss |
| 109 | Default + milliseconds | SELECT CONVERT(VARCHAR(26), GETDATE(), 109) | mon dd yyyy hh:mi:ss:mmmAM (or PM) |
| 110 | USA | SELECT CONVERT(VARCHAR(10), GETDATE(), 110) | mm-dd-yyyy |
| 111 | Japan | SELECT CONVERT(VARCHAR(10), GETDATE(), 111) | yyyy/mm/dd |
| 112 | ISO | SELECT CONVERT(VARCHAR(8), GETDATE(), 112) | yyyymmdd |
| 113 | Europe default + milliseconds | SELECT CONVERT(VARCHAR(24), GETDATE(), 113) | dd mon yyyy hh:mi:ss:mmm(24h) |
| 114 | - | SELECT CONVERT(VARCHAR(12), GETDATE(), 114) | hh:mi:ss:mmm(24h) |
| 120 | ODBC canonical | SELECT CONVERT(VARCHAR(19), GETDATE(), 120) | yyyy-mm-dd hh:mi:ss(24h) |
| 121 | ODBC canonical (with ms) | SELECT CONVERT(VARCHAR(23), GETDATE(), 121) | yyyy-mm-dd hh:mi:ss.mmm(24h) |
| 126 | ISO8601 | SELECT CONVERT(VARCHAR(23), GETDATE(), 126) | yyyy-mm-ddThh:mi:ss.mmm |
| 130 | Hijri | SELECT CONVERT(VARCHAR(26), GETDATE(), 130) | dd mon yyyy hh:mi:ss:mmmAM |
| 131 | Hijra | SELECT CONVERT(VARCHAR(25), GETDATE(), 131) | dd/mm/yyyy hh:mi:ss:mmmAM |