SQLServerCentral / SQL Server 7,2000 / T-SQL / DateAdd / Latest Posts

RE: DateAdd

sushila — Mon, 29 Aug 2005 18:58:00 GMT

Hey Mike - no one's offended! Just double checking to make sure!

RE: DateAdd

Mike-238404 — Mon, 29 Aug 2005 15:44:00 GMT

Yes I was asking the same thing. I though I should start a new thread since it was somthing different.

I appologize if it offended someone.

RE: DateAdd

sushila — Mon, 29 Aug 2005 14:57:00 GMT

mike - isn't this the same as what is being discussed on this other thread..?!?!other thread

RE: DateAdd

Mike-238404 — Mon, 29 Aug 2005 14:09:00 GMT

I thought the same thing but it shows the correct date and time. It's my local PC<G>

Still getting a startdate of 2003 -24 and nothing on 24 or +24

The filed is a smalldatetime on SQL 2000 .

If I do WHERE (DISCONTINUEDDATE >= '01/01/2005') I get 01/01/2005 and up correctly as well.

Thanks for all of the help!!

Mike

RE: DateAdd

Ninja's_RGR'us — Mon, 29 Aug 2005 13:55:00 GMT

SELECT TYPE,vendor,discontinueddate, datepart(quarter,[discontinueddate]) AS 'Quarter'from dbo.EOLWHERE DISCONTINUEDDATE > DateAdd(M,-24,GETDATE()) and DISCONTINUEDDATE < DATEADD(D, 1, DATEDIFF(D, 0, GetDate()))Order by Discontinueddate

RE: DateAdd

SQLBill — Mon, 29 Aug 2005 13:55:00 GMT

You say it goes from 2003 to 2009.

Run this:SELECT GETDATE()

That will show you what the server's date is set as. If you are getting 2009, it looks like your system date is off.

Note that Remi's suggestion does NOT have the quotes around the M in the DATEADD function, where yours did. Remi's is the correct way of doing it. If you want 24 months earlier than GETDATE(), use the -24 otherwise make it 24.

-SQLBill

RE: DateAdd

Mike-238404 — Mon, 29 Aug 2005 13:50:00 GMT

For some reason that makes it go from 2003 - 2009

I need current day plus 24 months so I can show 8 quarters of info at a time.

Thanks for the help.

Mike

RE: DateAdd

Ninja's_RGR'us — Mon, 29 Aug 2005 13:43:00 GMT

SELECT TYPE,vendor,discontinueddate, datepart(quarter,[discontinueddate]) AS 'Quarter'from dbo.EOLWHERE DISCONTINUEDDATE > DateAdd(M,-24,GETDATE())Order by Discontinueddate

DateAdd

Mike-238404 — Mon, 29 Aug 2005 13:41:00 GMT

Trying build this some that it will return 24 months from the current day. What am I doing wrong??

SELECT TYPE,vendor,discontinueddate, datepart(quarter,[discontinueddate]) AS 'Quarter'from EOL WHERE DISCONTINUEDDATE <DateAdd("M",24,GETDATE())and (DISCONTINUEDDATE = '01/01/2005')Order by Discontinueddate

Thanks