easier way to do this? (time interval)
| From: | Thoenen, Peter Mr. EPS | Date: | Fri, 11 Oct 2002 04:33:53 +0000 |
| Subject: | easier way to do this? (time interval) | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-22333@lists.php.net to get a copy of this message | ||
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
##################################
Peter Thoenen - Systems Programmer
Commercial Communications
Camp Bondsteel, Kosovo
##################################
"Stumbled Upon"...heh (Score:5, Funny) /.
by $carab on 23:00 23 August 2002 (#4131637)
"ForensicTec officials said they stumbled upon the military networks about
two months ago, while checking on network security for a private-sector
client."
Someone new to a Dvorak probably tried to type in "lynx
http://www.google.com" but instead got "nmap -v
-p 1-1024 -sS -P0 army.mil
-T paranoid".