datetime operation 1

[Luzian]

I need to know how to mathematically operate on the datetime SQL data-type.
Here's some psudo-code to describe my problem

IF now is later than (login time + 20 minutes) THEN
[tab]...
END

 

[SQLDenis]

if getdate() > dateadd(mi,20,login time)
begin

end



test
select dateadd(mi,20,getdate())

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

 

[Luzian]

thank you SQLDenis

 

[SQLBill]

Luzian,

Take a look at the FAQ section in this forum. Scroll down to the 'Date and Time Tips and tricks' FAQ. There are some good FAQs for using DATETIME. Especially look at FAQ183-5842 by vongrunt. It discusses manipulating dates and times.

-SQLBill

Posting advice: FAQ481-4875