DbSchema | 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 below 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.