Published on: 07 Aug, 2020

How to remove time from datetime in TSQL?

Tumblr Digg Google Plus

If you want to remove a time from datetime in TSQL, you have multiple options to do that. You can use CONVERT or CAST function by converting the datetime to date type only.

Here are the 3 options you can use.

DECLARE @CurrentDate DateTime = GetDate()
SELECT @CurrentDate As CurrentDateTime

--OPTION 1
SELECT CONVERT(DATE,@CurrentDate) AS Option1

--OPTION 2
SELECT CAST(@CurrentDate AS DATE) AS Option2

--OPTION 3
SELECT CONVERT(char(10), @CurrentDate,126) AS Option3

Comments

There are no comments available.

Write Comment
0 characters entered. Maximum characters allowed are 1000 characters.