chikennugget180
New Member
- Messages
- 2
- Reaction score
- 0
- Points
- 0
Good evening, I'm currently hosting a website ( http://critijeux.pcriot.com ) where I post articles and news, and I'm having a problem with the hours used in the MySQL database.
When I post something, it should display "posted on a certain date, at xx:xx ..." next to the title of the news/review.
I live in France, and the server is based in the USA, so when I post an article, the hour associated with the message is the US localtime and not France's one.
My requests use NOW() to set the dates and hours, example:
'INSERT INTO news(title,content,date_post) VALUES
title,:content,NOW())' (in PHP)
I'd like to know if there is a way to change the server's time so I can have the right time with my messages ?
Thank you in advance,
Yannis M'rad
When I post something, it should display "posted on a certain date, at xx:xx ..." next to the title of the news/review.
I live in France, and the server is based in the USA, so when I post an article, the hour associated with the message is the US localtime and not France's one.
My requests use NOW() to set the dates and hours, example:
'INSERT INTO news(title,content,date_post) VALUES
title,:content,NOW())' (in PHP)I'd like to know if there is a way to change the server's time so I can have the right time with my messages ?
Thank you in advance,
Yannis M'rad