Compare datetimes

[Javier]

Hi

I need to retrieve data from a table comparing datetimes. I mean I've a
table with a datetime data and I'll need to retrieve rows with date time

now and date time < now + 5 minutes...

Is this posible ? Which is the best / easy way ?

Thanks in advance

J

[Simon Hayes]

"Javier" <jl****@manresa.net> wrote in message
news:cu**********@news.ya.com...

Hi

I need to retrieve data from a table comparing datetimes. I mean I've a
table with a datetime data and I'll need to retrieve rows with date time

now and date time < now + 5 minutes...

Is this posible ? Which is the best / easy way ?

Thanks in advance

J

Check out DATEADD() in Books Online.

select col1, col2, ...
from dbo.MyTable
where dtcol > getdate()
and dtcol < dateadd(mi, 5, getdate())

Simon

[Hugo Kornelis]

On Mon, 07 Feb 2005 20:34:05 +0100, Javier wrote:

Hi

I need to retrieve data from a table comparing datetimes. I mean I've a
table with a datetime data and I'll need to retrieve rows with date time

now and date time < now + 5 minutes...

Is this posible ? Which is the best / easy way ?

Hi Javier,

SELECT Column1, Column2, ...
FROM MyTable
WHERE MyDatetimeColumn > CURRENT_TIMESTAMP
AND MyDatetimeColumn < DATEADD(minute, 5, CURRENT_TIMESTAMP)

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)