Mega Code Archive
Categories
/
MSSQL
/
Date Timezone
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>