Mega Code Archive

 

Categories / MSSQL / Date Timezone

 

CONVERT date to varchar

1> 2> --Nested Functions 3> 4> SELECT CONVERT(VarChar(20), GETDATE(), 101) 5> 6> GO -------------------- 10/14/2006 (1 rows affected) 1>