CONVERT(VarChar(50), GETDATE(), 104)
3> SELECT 'German Date: ' + CONVERT(VarChar(50), GETDATE(), 104)
4> GO
---------------------------------------------------------------
German Date: 12.10.2006
(1 rows affected)
1>
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(), 103) | | |
6. | CONVERT(VarChar(50), GETDATE(), 100) | | |
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' | | |