Date Conversion

[frank43]

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

[yosiasz]

look at the following

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

[ScottPletcher]

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