Re: easier way to do this? (time interval)
| From: | David Robley | Date: | Fri, 11 Oct 2002 10:23:25 +0000 |
| Subject: | Re: easier way to do this? (time interval) | ||
| References: | 1 | Groups: | php.db php.db |
| Request: | Send a blank email to php-db+get-22339@lists.php.net to get a copy of this message | ||
In article
<A733FF9B1FB0F441B3A6209FF71030E501065A00@bondsteel2.areur.army.mil>,
Peter.Thoenen@bondsteel2.areur.army.mil says...
> Hello,
>
> Curious if there is an easier way to do this (using just SQL and not PHP).
> SQL seems powerful enough to do this but can't think of the synatx. Note, I
> am using MySQL so no sub-selects (or other useful items). Basically trying
> to pull all records for a 24 hour period but instead of 0000->2400,
> 0700->0700 (next day).
>
> if (date("H")>7){
>
> $query=mysql_query("
> SELECT dtg
> FROM techs
> WHERE
> tech='$user'
> AND
> DAYOFMONTH(NOW())=DAYOFMONTH(dtg)
> AND
> HOUR(dtg)>=7
> ");
>
> } else {
>
> $query=mysql_query("
> SELECT dtg
> FROM techs
> WHERE
> tech='$user'
> AND
> (
> (DAYOFMONTH(NOW())=DAYOFMONTH(dtg) AND HOUR(dtg)<7)
> OR
> ((DAYOFMONTH(NOW())-1)=DAYOFMONTH(dtg) AND HOUR(dtg)>=7)
> )
> ");
>
> }
>
> Cheers,
>
> -peter
I'd imagine that with a judicious use of mysql's IF statement and
HOUR(NOW()) you could do pretty much what you want. I can't be hanged
going through the docs right now, or I'd have a try at the syntax for you
:-)
--
David Robley
Temporary Kiwi!
Quod subigo farinam