Mega Code Archive

 

Categories / MSSQL / Date Timezone

 

CONVERT(VarChar(50), GETDATE(), 102)

1> 2> 3> SELECT 'ANSI Date: ' + CONVERT(VarChar(50), GETDATE(), 102) 4> GO ------------------------------------------------------------- ANSI Date: 2006.10.12 (1 rows affected) 1>