Date Conversion

Transact-SQL
1

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

2

look at the following

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

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