sql server mseq: Date Range -- sql server mseq

Date Range

Daniell
2/28/2006 12:41:27 PM

sql server mseq: I have a query that I have to place a beginning and ending date to select the
information needed. The date is always 30 days for the current date. Is
there a way to set up a query to select current date minus 30 days that I
will not have to change the date each time?

Re: Date Range

Daniell
2/28/2006 2:49:07 PM

Thanks Hugo, I will give that a try.

[quoted text, click to view]

Re: Date Range

Hugo Kornelis
2/28/2006 10:31:26 PM

[quoted text, click to view]

Hi Daniell,

SELECT DATEADD(day, -30, CURRENT_TIMESTAMP)

--

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server mseq group.