How to extract date from a DateNow() in YYYYMMDD format in SQL Server

date sql-server-2005 getdate
Sree picture Sree · Jan 21, 2014 · Viewed 13.9k times · Source

Got a specific requirement that we should extract only date and in YYYYMMDD format from GETDATE() in Sql-Server 2005.

How can I accomplish this.

Thanks

Answer

Jerodev picture Jerodev · Jan 21, 2014

You can use formatting in your sql query: http://www.sql-server-helper.com/tips/date-formats.aspx

Your query should be

SELECT CONVERT(VARCHAR(8), GETDATE(), 112) AS [YYYYMMDD]

Related questions

How to calculate age (in years) based on Date of Birth and getDate()

I have a table listing people along with their date of birth (currently a nvarchar(25)) How can I convert that to a date, and then calculate their age in years? My data looks as follows ID Name DOB 1 John 1992-01…

Read More
How to compare two dates to find time difference in SQL Server 2005, date manipulation

I have two columns: job_start job_end 2011-11-02 12:20:37.247 2011-11-02 13:35:14.613 How would it be possible using T-SQL to find the raw amount of time that has passed between when the job started and when the job ended? I …

Read More
Get the week start date and week end date from week number

I have a query that counts member's wedding dates in the database. SELECT SUM(NumberOfBrides) AS [Wedding Count] , DATEPART( wk, WeddingDate) AS [Week Number] , DATEPART( year, WeddingDate) AS [Year] FROM MemberWeddingDates GROUP BY DATEPART(year, WeddingDate), DATEPART(wk, WeddingDate) ORDER …

Read More