Post
Ask Question

SQL Server Transact Basic to Expert - Display Current date in dd/mm/yy format

This blog shows how to display the current dae in dd/mm/yy using SQL query

Example:

SELECT CONVERT(varchar(20), GETDATE(), 103)

The expected result would be 16/06/11
Next Recommended Reading SQL Server Transact Basic to Expert - Display Current date in mm/dd/yyyy format