|
| |
| 13. 3. 20. CONVERT(varchar(20), GETDATE()) |
|
|
|
3> SELECT
4> 'returned as date'=GETDATE(),
5> 'returned as string'=CONVERT(varchar(20), GETDATE())
6> GO
returned as date returned as string
----------------------- --------------------
2008-08-17 13:20:33.890 Aug 17 2008 1:20PM
(1 rows affected)
1>
2>
|
|
| 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 | | |
|