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.