Mega Code Archive

 

Categories / MSSQL / Date Timezone

 

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)