Selecting Date Time field, difference in minutes

[C.F. Scheidecker Antunes]

Hello all,

I wonder if is there any way to select from a table all the records
which has a Date Field that is at least five minutes old?

In other words, I have a table with a date field and I need to select
all the records that are older than five minutes, has their date field
updated
before five minutes.

Usually I do it with days by using the to_days() function and comparing
the date to now: (to_dayss(now()) - to_days(somedate)).

I wonder if I could do the same with minutes.

Thanks in advance.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

[Aggro]

C.F. Scheidecker Antunes wrote:

Hello all,

I wonder if is there any way to select from a table all the records
which has a Date Field that is at least five minutes old?

In other words, I have a table with a date field and I need to select
all the records that are older than five minutes, has their date field
updated
before five minutes.

Usually I do it with days by using the to_days() function and comparing
the date to now: (to_dayss(now()) - to_days(somedate)).

I wonder if I could do the same with minutes.

See:

http://www.mysql.com/doc/en/Date_and...functions.html

So for example to get what time it was 5 minutes ago do:

select (now() - interval 5 minutes );

[Aggro]

C.F. Scheidecker Antunes wrote:

Hello all,

I wonder if is there any way to select from a table all the records
which has a Date Field that is at least five minutes old?

In other words, I have a table with a date field and I need to select
all the records that are older than five minutes, has their date field
updated
before five minutes.

Usually I do it with days by using the to_days() function and comparing
the date to now: (to_dayss(now()) - to_days(somedate)).

I wonder if I could do the same with minutes.

See:

http://www.mysql.com/doc/en/Date_and...functions.html

So for example to get what time it was 5 minutes ago do:

select (now() - interval 5 minutes );