SQLTeam.com | Weblogs | Forums

Date Conversion

How do I convert yyyy-mm-dd to dd/mm/yyyy?
thanks

look at the following

select convert(varchar(10), getdate(), 120 ), 
           convert(varchar(10), getdate(), 103 )

CONVERT(varchar(10), 'yyyy-mm-dd', 103)