SQL Server - How to return Date Only from GETDATE



The basic query that returns the date and time for SQL Server is

SELECT getdate();

This query will return the current date & time of your local machine. In my case, the result is:

13.04.2020 18:54:05

1.The simplest way to return Date Only

Just execute the next query:

SELECT CONVERT(date, getdate())

In my case, the result is:

2020-04-13

2.The CONVERT method

This time, we are going to convert our results to VARCHAR, set a character limit and a display style with the next query:

SELECT CONVERT(VARCHAR(10), getdate(), 101);

The result:

04/13/2020    

Let’s break it down to understand it better:

  • VARCHAR - this is the results’ data type;
  • (10) - this is the maximum number of characters;
  • getdate() - this is the expression used to return the date;
  • 101 - this is the style of the result (see the table bellow for more styles).

There are other styles that you can use for your results:

Style Result
101 mm/dd/yyyy
102 yyyy.mm.dd
103 dd/mm/yyyy
104 dd.mm.yyyy
105 dd-mm-yyyy
106 dd mon yyyy
107 Mon dd, yyyy
109 Mon dd yyyy
110 mm-dd-yyyy
111 yyyy/mm/dd

The 108 is missing because it will return the time.

This is all. Choose the right format for you and you’re ready to go.