CONVERT(VarChar(50), GETDATE(), 100)
28>
29> SELECT 'Default Date: ' + CONVERT(VarChar(50), GETDATE(), 100)
30> GO
----------------------------------------------------------------
Default Date: Oct 12 2006 5:45PM
(1 rows affected)
Related examples in the same category
1. | CONVERT(varchar, getdate(), 1(2,3,4,5,6)) | | |
2. | CONVERT(varchar,GETDATE(),108) 'hh:mm:ss' | | |
3. | CONVERT(varchar,GETDATE(),114) 'hh:mm:ss:mmm' | | |
4. | CONVERT(varchar,GETDATE(),113) 'dd Mmm yyyy hh:mm:ss:mmm' | | |
5. | CONVERT(VarChar(50), GETDATE(), 104) | | |
6. | CONVERT(VarChar(50), GETDATE(), 103) | | |
7. | CONVERT(VarChar(50), GETDATE(), 101) | | |
8. | CONVERT(VarChar(50), GETDATE(), 102) | | |
9. | Reference Date data type as string (char) | | |
10. | Format date: 'Mmm dd yyyy hh:mmdp' | | |
11. | Format date: 'mm/dd/yyyy' | | |