CONVERT(VarChar(50), GETDATE(), 103)
1> SELECT 'UK/French Date: ' + CONVERT(VarChar(50), GETDATE(), 103)
2>
------------------------------------------------------------------
UK/French Date: 12/10/2006
(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(), 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' | | |