CONVERT date to varchar : Date Data Type « Date Timezone « SQL Server / T-SQL






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>
           
       








Related examples in the same category

1.Get current date in procedure