How to write a SQL Query to Return Date Part Only from a SQL Server Datetime datatype with example. It is one of the SQL Server Frequently Asked Question. For this SQL Date Part example, We are going to use the below-shown data
How to Return Date Part Only from a SQL Server Datetime datatype Example 1
In this SQL Server example, first, we are going to declare a DateTime variable, and also use the GETDATE() function. Next, we are going to use the CONVERT, CAST, DATEADD, and DATEPART functions to extract the date part only from a SQL server Datetime Datatype.
-- Query to Return Date Part from a Datetime datatype in SQL Server DECLARE @DateAdd datetime2 = '2017-05-12 14:24:04.1234567' SELECT GETDATE() AS ToDay; -- Using Convert without Format on Variable, and GETDATE() SELECT CONVERT(date, GETDATE()) AS [ToDays Date 1]; SELECT CONVERT(date, @DateAdd) AS [ToDays Date 2]; -- Using Convert with Format on Variable, and GETDATE() SELECT CONVERT(VARCHAR(10), GETDATE(), 111) AS [ToDays Date 3]; SELECT CONVERT(VARCHAR(10), @DateAdd, 111) AS [ToDays Date 4]; -- Using Cast Function on Variable, and GETDATE() SELECT CAST(GETDATE() as date) AS [ToDays Date 5]; SELECT CAST(@DateAdd as date) AS [ToDays Date 6]; -- Worst case Scenario SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE())) AS [ToDays Date 7]; SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, @DateAdd)) AS [ToDays Date 8];
How to Return Date Part Only from a Datetime datatype Example 2
In this SQL Server Frequently Asked Question, we will extract the data part only from the Hire date column.
-- Query to Return Date Part from a Datetime datatype in SQL Server USE [SQL Tutorial] GO SELECT [FirstName] + [LastName] AS [Full Name] ,[Education] ,[Occupation] ,[YearlyIncome] ,[Sales] ,[HireDate] ,CONVERT(date, [HireDate]) AS [HireDate 1] ,CONVERT(date, [HireDate], 111) AS [HireDate 2] ,CAST([HireDate] AS date) AS [HireDate 3] FROM [Employee]