timestamp advice needed !

[rab54]

Hi guys -

I need to pull out all recs that have been altered in the last 5 mins -

I have added a timestamp column -

Can I say -

SELECT name FROM details where timestamp BETWEEN NOW() and NOW (5 mins ago)

Any ideas ?

cheers

Rab

 

[sleipnir214]

No.

First, because now() doesn't take input.

Second, because you could do it more efficiently. There's no point in checking for the upper bound now() when that is by definition always going to be the upper bound anyway.


SELECT name FROM details where timestamp_column > now() - interval 5 minute


Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[rab54]

AHA ! Thank you kind sir ! You are a genius ;-)

cheers

Rab