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