Hi,
I am using a shared hosting which has EST US time, since i am on shared hosting that's why i cannot change the server time zone but i wanted to display local Indian time to my users.
What is a solution for this?
Thanks
Hi,
I am using a shared hosting which has EST US time, since i am on shared hosting that's why i cannot change the server time zone but i wanted to display local Indian time to my users.
What is a solution for this?
Thanks
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_convert-tz
You can use this function to let mysql do the transformation, or choose to do it in your scripts.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.