How do I convert SQL getdate() function into a string in dd/mm/yyyy format?

Question

How do I convert SQL getdate() function into a string in dd/mm/yyyy format?

Answer 1

Try:

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

There's more info on the different conversion codes here.

Answer 2

Use conversion code 103

convert(varchar, getdate(), 103) 

Answer 3

this worked for me

replace(convert(char(11),getdate(),113),' ','-')