|
| |
| 13. 3. 2. Values for the style argument of the CONVERT function when you convert a datetime expression to a character expression. |
|
|
|
Style Number Style Number Output Type Style
without Century (yy) with Century (yyyy)
- 0 or 100 Default mon dd yyyy hh:miAM (or PM)
1 101 USA mm/dd/yyyy
2 102 ANSI yyyy.mm.dd
3 103 British/French dd/mm/yyyy
4 104 German dd.mm.yyyy
5 105 Italian dd-mm-yyyy
6 106 - dd mon yyyy
7 107 - mon dd, yyyy
- 8 or 108 - hh:mm:ss
- 9 or 109 Default + mon dd yyyy hh:mi:ss:mmmAM
milliseconds (or PM)
10 110 USA mm-dd-yy
11 111 JAPAN yy/mm/dd
12 112 ISO yymmdd
- 13 or 113 Europe default + dd mon yyyy hh:mi:ss:mmm (24h)
milliseconds
14 114 - hh:mi:ss:mmm (24h)
20 or 120 ODBC canonical yyyy-mm-dd hh:mi:ss(24h)
21 or 121 ODBC canonical + yyyy-mm-dd hh:mi:ss.mmm(24h)
milliseconds
|
|
| 13. 3. CONVERT | | 13. 3. 1. | CONVERT function syntax | | | | 13. 3. 2. | Values for the style argument of the CONVERT function when you convert a datetime expression to a character expression. | | | | 13. 3. 3. | select CONVERT (INTEGER , '123') | | | | 13. 3. 4. | The syntax of the CONVERT function CONVERT(data_type, expression [, style]) | | | | 13. 3. 5. | CONVERT(varchar,BillingDate,100) 'Mmm dd yyyy hh:mmdp' | | | | 13. 3. 6. | CONVERT(varchar,BillingDate,101) 'mm/dd/yyyy' | | | | 13. 3. 7. | CONVERT(varchar,BillingDate,103) 'dd/mm/yyyy' | | | | 13. 3. 8. | CONVERT() function requires two arguments: the first for the target data type and the second for the source value. | | | | 13. 3. 9. | SELECT 'Default Date: ' + CONVERT(VarChar(50), GETDATE(), 100) | | | | 13. 3. 10. | SELECT 'US Date: ' + CONVERT(VarChar(50), GETDATE(), 101) | | | | 13. 3. 11. | SELECT 'ANSI Date: ' + CONVERT(VarChar(50), GETDATE(), 102) | | | | 13. 3. 12. | SELECT 'UK/French Date: ' + CONVERT(VarChar(50), GETDATE(), 103) | | | | 13. 3. 13. | SELECT 'German Date: ' + CONVERT(VarChar(50), GETDATE(), 104) | | | | 13. 3. 14. | SELECT CONVERT(VarChar(50), @Num, 0) | | | | 13. 3. 15. | CONVERT(datetime, '20000704') | | | | 13. 3. 16. | SELECT CONVERT(datetime, '10.12.99',1) | | | | 13. 3. 17. | SELECT CONVERT(datetime, '10.12.99',4) | | | | 13. 3. 18. | CONVERT(char(10), GETDATE(), 112) | | | | 13. 3. 19. | CONVERT(varchar(10), advance, 2) | | | | 13. 3. 20. | CONVERT(varchar(20), GETDATE()) | | | | 13. 3. 21. | The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. | | | | 13. 3. 22. | CONVERT(char(8), BillingDate, 1) and CONVERT(varchar(9), PaymentTotal, 1) | | | | 13. 3. 23. | Conversion failed when converting the varchar value 'abc' to data type int. | | | | 13. 3. 24. | CONVERT(varchar(12), OrderDate, 5) | | | | 13. 3. 25. | Compare date type value after converting | | | | 13. 3. 26. | Use convert function with variables | | |
|