Need helps with date and time in PHP/MySQL

[rija]

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

[Jerry Stuckle]

rija wrote:

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

Since you're asking about MySQL operations and not PHP, might I suggest
you ask in comp.database.mysql - where all the MySQL users hang out?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================