Re: [PHP] Alternate to timediff() (might be slightly 0T)

2005-04-09 Thread Ryan A
Hmmm. we have a new sql guru on the list eh? welcome master... :-) Thanks mate. -Ryan On 4/9/2005 8:18:10 PM, Greg Donald ([EMAIL PROTECTED]) wrote: > On Apr 9, 2005 1:09 PM, Ryan A <[EMAIL PROTECTED]> wrote: > > > So how can I compare 2 timedates which are: > > > > > > now() and now(

Re: [PHP] Alternate to timediff() (might be slightly 0T)

2005-04-09 Thread Greg Donald
On Apr 9, 2005 1:09 PM, Ryan A <[EMAIL PROTECTED]> wrote: > So how can I compare 2 timedates which are: > > now() and now() + 5 mins > > to see if I get a positive or negitive value? mysql> select NOW() > DATE_ADD( NOW(), INTERVAL 5 MINUTE ); +--+ |

[PHP] Alternate to timediff() (might be slightly 0T)

2005-04-09 Thread Ryan A
Hey, Reading the time and date functions of MySql I see that to compare my two timedates I would need to go with TIMEDIFF, but theres a "note" there that states: TIMEDIFF() was added in MySQL 4.1.1. and our host is running 4.0 and another 3.23.x So how can I compare 2 timedates which are: now()