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
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
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
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
>
sage-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 24, 2001 2:58 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Re: Date/Time Query Help
On Tue, 24 Jul 2001 15:09:14 -0400, [EMAIL PROTECTED]
(Ryan Shrout) wrote:
>I need a MySQL query that will select all the entries in i
On Tue, 24 Jul 2001 15:09:14 -0400, [EMAIL PROTECTED]
(Ryan Shrout) wrote:
>I need a MySQL query that will select all the entries in it made within the
>last hour.
>
>I tried this, but it is not working correctly, what am I doing wrong?
>
>SELECT *
6 matches
Mail list logo
