[font="Courier New"]You can convert current date as you required by below piece of code

select convert(varchar(25),getdate(),101)

You can change the last variable value from 101 to 121 and each value represent one datetime format[/font]