RE: [PHP] Re: Date/Time Query Help

2001-07-24 Thread Shrout, Ryan
lto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 3:43 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] Re: Date/Time Query Help On Tue, 24 Jul 2001 15:23:10 -0400, [EMAIL PROTECTED] (Ryan Shrout) wrote: >WHERE session.Date > DATE_SUB(NOW(), INTERVAL 1 HOUR) is equal to: > >WHERE 2001

Re: [PHP] Re: Date/Time Query Help

2001-07-24 Thread Bopolissimus Platypus
On Tue, 24 Jul 2001 15:23:10 -0400, [EMAIL PROTECTED] (Ryan Shrout) wrote: >WHERE session.Date > DATE_SUB(NOW(), INTERVAL 1 HOUR) is equal to: > >WHERE 2001-07-24 15:03:24 > SUBTRACTION( 2001-07-24 15:30:21, 00:01:00) = >WHERE 2001-07-24 15:03:24 > 2001-07-24 14:30:21 i just tested on my box (d

RE: [PHP] Re: Date/Time Query Help

2001-07-24 Thread Shrout, Ryan
Heh. :) So, does anyone know what I am doing wrong? Ryan Shrout -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 3:34 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] Re: Date/Time Query Help On Tue, 24 Jul 2001 15:23:10 -0400, [EMAIL

Re: [PHP] Re: Date/Time Query Help

2001-07-24 Thread Bopolissimus Platypus
On Tue, 24 Jul 2001 15:23:10 -0400, [EMAIL PROTECTED] (Ryan Shrout) wrote: >Think of it this way: > >WHERE session.Date > DATE_SUB(NOW(), INTERVAL 1 HOUR) is equal to: > >WHERE 2001-07-24 15:03:24 > SUBTRACTION( 2001-07-24 15:30:21, 00:01:00) = >WHERE 2001-07-24 15:03:24 > 2001-07-24 14:30:21 >

RE: [PHP] Re: Date/Time Query Help

2001-07-24 Thread Shrout, Ryan
Think of it this way: WHERE session.Date > DATE_SUB(NOW(), INTERVAL 1 HOUR) is equal to: WHERE 2001-07-24 15:03:24 > SUBTRACTION( 2001-07-24 15:30:21, 00:01:00) = WHERE 2001-07-24 15:03:24 > 2001-07-24 14:30:21 That seems right now, but it doesn't work Ryan -Original Message- From: [