Need helps with date and time in PHP/MySQL

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

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
Notes that either and is recorded on the
server GMT -8

Any help could be appreciated

Re: Need helps with date and time in PHP/MySQL

rija wrote:
Quoted text here. Click to load it

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.

Site Timeline