Re: Re: Date/Time Query Help
| From: | (Bopolissimus Platypus) | Date: | Tue, 24 Jul 2001 19:34:18 +0000 |
| Subject: | Re: Re: Date/Time Query Help | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-59411@lists.php.net to get a copy of this message | ||
On Tue, 24 Jul 2001 15:23:10 -0400, Rshrout@krauss-maffeicorp.com
(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
>
>That seems right now, but it doesn't work
DATE_SUB. heh. that'll teach me not to read the whole
post and THINK about it :).