Yes, that makes sense.
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 18, 2004 9:05 PM
To: Viswanatha Rao
Cc: 'Wesley Furgiuele'; [EMAIL PROTECTED]
Subject: Re: select rows by compare on datetime column - more on time
decrement
You
Wesley Furgiuele [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 18, 2004 3:11 PM
To: Viswanatha Rao
Cc: [EMAIL PROTECTED]
Subject: Re: select rows by compare on datetime column - more on time
decrement
What version of MySQL are you using? You have different options.
http://dev.mysql.
Re: select rows by compare on datetime column - more on time
decrement
What version of MySQL are you using? You have different options.
http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
Look at DATE_SUB() and SUBDATE()/SUBTIME().
The time part of the query would look something l
What version of MySQL are you using? You have different options.
http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
Look at DATE_SUB() and SUBDATE()/SUBTIME().
The time part of the query would look something like DATE_FORMAT(
DATE_SUB( NOW(), INTERVAL 4 HOUR ), '%H:%i:%s' ), or somethi
I have to select mysql rows based on the following condition.
Time t1 = (current time - 4 hours);
Time t2 = (current time - 8 hours);
In my case, I want to select all those rows that have start times
(1) between current time and t1
(2) between time t1 and t2
... and so on
So I have to somehow subt
