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
kyandebishop 0 Newbie Poster
MitkOK 61 Junior Poster
Why do you need CURDATE() if you want to get time ?
CURDATE() returns you the date part of the mysql server's datetime
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.