SQLServerCentral / Administration / SQL Server 7,2000 / Select Datepart / Latest Posts

RE: Select Datepart

brendt hess — Mon, 19 Jun 2006 15:29:00 GMT

Of course, I never noticed the "Or is there some other way to do it" portion of the post 8-O

RE: Select Datepart

brendt hess — Mon, 19 Jun 2006 15:28:00 GMT

Perhaps, but the questioner specifically requested a method using DatePart. I use this when generating a YYYYMMDDHHNN strings, in preference to stripping formatting out of a CONVERTed datetime, because it is far more readable.

RE: Select Datepart

John Rowan — Mon, 19 Jun 2006 14:53:00 GMT

I just realized that I pasted the wrong section into my post.

This returns the same result as Brendt's DatePart/Cast example, but with less function calls:

SELECT CONVERT(varchar,GETDATE(),112)

RE: Select Datepart

Nali — Mon, 19 Jun 2006 14:41:00 GMT

That worked great, thanks!

RE: Select Datepart

brendt hess — Mon, 19 Jun 2006 14:38:00 GMT

Yes, there is. This code will do what you need:SELECT Cast(Datepart(yyyy, GetDate()) AS char(4)) + Right('0' + Cast(DatePart(mm, GetDate()) AS Varchar(2)), 2) + Right('0' + Cast(DatePart(dd, GetDate()) AS Varchar(2)), 2)

RE: Select Datepart

John Rowan — Mon, 19 Jun 2006 14:22:00 GMT

print convert(varchar,@datetime,112)

Select Datepart

Nali — Mon, 19 Jun 2006 14:12:00 GMT

Is there a way for me to use the Datepart function so that it would return today's date as:

20060619

Or is there another way I can do it?

The below didn't quite get me what I needed.

SELECT DATEPART(YYYY, GETDATE()), DATEPART(MM,GETDATE()) , DATEPART(DD, GETDATE())

Thanks!