By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,034 Members | 1,777 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,034 IT Pros & Developers. It's quick & easy.

Need helps with date and time in PHP/MySQL

P: n/a

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

Nov 20 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
==================
Nov 20 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.