Mega Code Archive

 

Categories / MSSQL / Date Timezone

 

CONVERT(varchar, getdate(), 1(2,3,4,5,6))

1> SELECT 2>    CONVERT(varchar, getdate(), 1), 3>    CONVERT(varchar, getdate(), 2), 4>    CONVERT(varchar, getdate(), 3), 5>    CONVERT(varchar, getdate(), 4), 6>    CONVERT(varchar, getdate(), 5), 7>    CONVERT(varchar, getdate(), 6) 8> GO ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------- ----- 10/12/06                       06.10.12                       12/10/06                       12.10.06                       12-10-06                       12 Oct 06 (1 rows affected) 1>