DbSchema Database Designer

DbSchema | SQL Server - How to return Date Only from GETDATE

Publish on DbSchema Blog >>>

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:


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:


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.

Visually Manage Databases using DbSchema

DbSchema is a databases client and visual designer. DbSchema has a free Community Edition, which can be downloaded here.
DbSchema main features include:

DbSchema Designer alt >

Interactive Diagrams

Design tables, column and foreign keys directly in diagrams, by double-clicking them. Changes will be saved to the design model and, if DbSchema is connected to the database also into the database. More.

Connection Dialog alt >

Simple Connection Dialog

Choose the database location, the user and password, and simply get connected. Choose 'Edit Manually' into the JDBC URL combo to enter a custom URL. More.

Relational Data Explorer alt >

Relational Data Explorer

Explore data from multiple tables simultaneously, using foreign keys or virtual foreign keys. Double-click cells to edit the data. More.

Query Builder alt >

Query Builder

Create SQL Queries featuring JOINS, GROUP BY, ORDER BY just using the mouse. More.

SQL Query Editor alt >

SQL Query Editor

Edit and execute SQL Queries. The editor is autocompletion-enabled. More.

Schema Synchronization alt >

Design Schema in Team & Schema Deployment

DbSchema is using the design model, a copy of the schema structure, independent of the database.
The design model can be saved to file and shared in a team.
Connecting to another database you may compare the design model with the database, commit the differences or merge them in the design model. More.

Dark Theme alt >

Dark Theme

Configurable styles & dark theme. More.

Many features are available in the free Community edition.
The Pro edition adds capabilities to save the design to the model file, design schema in team and deploy the schema on multiple databases.

DbSchema can be downloaded for free. No registration is required.