Friday, March 9, 2012

How to subtract minutes from the date?

I want to fetch all the records which are 2 minutes older
How can I do it?dateadd()

It can take negative values...|||SELECT *
FROM aTable
WHERE aDateColumn < DateAdd(minute, -2, GetDate())-PatP

No comments:

Post a Comment