http://www.sql-server-helper.com/tips/date-formats.aspx[DD/MM/YY] :SELECT convert(varchar(8), Getdate(), 3)[DD/MM/YYYY] :SELECT convert(varchar(10), Getdate(), 103)