DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)

- PHP (http://www.daniweb.com/forums/forum17.html)

- - Php (http://www.daniweb.com/forums/thread89873.html)

kyandebishop

Sep 17th, 2007 3:46 am

Php

I have writen a script to display a daily devotion every day and stored the message in the Mysql database. i am in the Central time zone but our server seems to be in Pacific time zone. I hosted the site with some guys godaddy.cm. The problem is the message will change two hours after midnight. i have phpMyadm but I do not know how to set CURDATE() to return the cetral time.
any help appreciated.
I am an intermediate level skillwise
kyan

MitkOK

Sep 18th, 2007 6:17 am

Re: Php

Why do you need CURDATE() if you want to get time ?

Quote:

CURDATE() returns you the date part of the mysql server's datetime

All times are GMT -4. The time now is 11:42 am.