| 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 |