Posted by rija on 11/20/06 14:04

Hi folks,
I need help regarding date and time comparison in PHP and MySQL
My website is hosted in the USA (GMT - 8)
And It is managed in Madagascar (GMT + 3)
Want to consider DATE in Madagascar not in USA -
MySQL CONVERT_TZ's function doesn't work

So, how can I do the following:
1. Today's visits
$query = "SELECT count(*) FROM visits WHERE now() = date";

2. Articles on the website appear only after 6 AM (GMT +3) compared to
the date_publication
$query = "SELECT n_edition FROM $table WHERE NOW() >
DATE_SUB(date_publication, INTERVAL 16 HOUR) ORDER BY n_edition DESC
LIMIT 1" ;

I don't know how to use DATE_ADD and DATE_SUB regarding the problem
below.
Notes that either visits.date and editions.date is recorded on the
server GMT -8

Any help could be appreciated

[Back to original message]