DbSchema Database Designer

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.

DbSchema → Your Trusted Partner in Database Design

Simplify complex database workflows and improve productivity with DbSchema's advanced design and management tools

Visual Design & Modeling
Visual Design & Schema Layout

➤ Create and manage your database schema visually through a user-friendly graphical interface.

➤ Easily arrange tables, columns, and foreign keys to simplify complex database structures, ensuring clarity and accessibility.

GIT & Collaboration
Version Control & Collaboration

➤ Manage schema changes through version control with built-in Git integration, ensuring every update is tracked and backed up.

➤ Collaborate efficiently with your team to maintain data integrity and streamline your workflow for accurate, consistent results.

Data Explorer & Query Builder
Relational Data & Query Builder

➤ Seamlessly navigate and visually explore your database, inspecting tables and their relationships.

➤ Build complex SQL queries using an intuitive drag-and-drop interface, providing instant results for quick, actionable insights.

Interactive Documentation & Reporting
HTML5 Documentation & Reporting

➤ Generate HTML5 documentation that provides an interactive view of your database schema.

➤ Include comments for columns, use tags for better organization, and create visually reports.