affiliate_link

Thursday, April 16, 2009

Formatting DateTime to Date in SQL

Select convert(varchar(10),GetDate(),101)

Output: 04/16/2009

Select convert(varchar(10),GetDate(),103)

Output: 16/04/2009

No comments: