Return data part from SQL Server datetime(Current) datatype

In SQL Server there is following queries are as follows to get date part only from a SQL Server datetime datatype.

--Return only DATETIME part from Current DateTime in SQL Server.
select (getdate()) AS DATETIME

--Return only YEAR part from Current DateTime in SQL Server.
select YEAR(GETDATE()) AS YEAR

--Return only MONTH part from Current DateTime in SQL Server.
select MONTH(GETDATE()) AS MONTH 

--Return only DAY part from Current DateTime in SQL Server.
select DAY(GETDATE()) AS DAY

--Return Date, datatype which contains only a date with no time from Current DateTime in SQL Server.
SELECT CONVERT(date, getdate())

SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))
select cast(getdate() as date)

--This returns DATE as 'yyy/mm/dd' format:
SELECT CONVERT(VARCHAR(10),GETDATE(),111)
-- NOTE: 111 is the Japanese format. yyy/mm/dd

--This returns DATE as 'mm/dd/yyyy' format:
SELECT CONVERT(VARCHAR(10),GETDATE(),101) 
-- NOTE: 101 is the Japanese format. mm/dd/yyyy

--If you need result in varchar datatype you should go through.
select convert(DATE, GETDATE()) --2014-03-26
SELECT CONVERT(VARCHAR(10), GETDATE(), 111) --2014/03/26

• Tweet
• Share
• Share
• Share
• Share

About Admin

Beginner School is optimized for learning. This is useful for getting basic knowledge with easiest way. Tutorials, examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. With the help of other reference book and website, the motive to provide you easiest way to understand the coding, technology and other things.....

Related Post