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

Karthikeyan Anbarasan
13y
2.2k
0
0

Blog

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

Up Next

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

Ebook Download

View all

Introducing Microsoft SQL Server 2016

Read by 2.9k people

Download Now!

Learn

View all