I have the following:
#!/usr/local/bin/php
<?php
$offset = date("Z");
$sDate = '2010-09-16';
$sTime = '00:00:00';
$eDate = '2010-09-17';
$eTime = '00:00:00';
$tmpStart0 = date("$sDate $sTime");
$tmpEnd0 = date("$eDate $eTime");
$startDate = date("Y-m-d H:i:s",strtotime($tmpStart0 . "-" . "$offset
seconds"));
$endDate = date("Y-m-d H:i:s",strtotime($tmpEnd0 . "-" . "$offset seconds"));
$when = "timestamp BETWEEN \"$startDate\" AND \"$endDate\"";
echo "\n$offset\n$when\n\n";
?>
Which returns:
machine1 (AST) PHP 5.2.6:
-10800
timestamp BETWEEN "2010-09-16 03:00:00" AND "2010-09-17 03:00:00"
machine2 (MST) PHP 5.1.6:
-21600
timestamp BETWEEN "1969-12-31 17:00:00" AND "1969-12-31 17:00:00"
Aside from upgrading the second box, is there some other logic that is wrong?
Thanks.
--
Paul Halliday
Ideation | Individualization | Learner | Achiever | Analytical
http://www.pintumbler.org
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
