Mysql Change timezone for hosting

Question

I have a server in godaddy. In php i use that:

date_default_timezone_set('Asia/Beirut');

I try to change mysql timezone.

I try many thing but i can't have a solution.

This is what i did:

SET time_zone ="Asia/Beirut";

also i tried this:

SET time_zone ="LB";

But i receive this message:

Unknown or incorrect time zone: 'Asia/Beirut'

this message also appear for LB

How Can i change my current mysql time zone to my own Lebanon Beirut ???

DATE(phonecall.db_nextdate)=CURDATE()

https://stackoverflow.com/questions/930900/how-do-i-set-the-time-zone-of-mysql — Barclick Flores Velasquez, Aug 26 '17 at 06:47
I recommend you leave mysql and the server with UTC timezone, and when it presents the values performs the conversion to the local date — rikardo_paiva, Aug 26 '17 at 06:50
@rikardo_paiva how can i change in my query to my local date i use curdate() to do that can you please check above — mohamad mohamad, Aug 26 '17 at 06:57

score 0 · Answer 1 · answered Aug 26 '17 at 12:38

0

change it in using htaccess

SetEnv TZ Asia/Beirut

OR

php_value date.timezone 'Asia/Beirut'

answered Aug 26 '17 at 12:38

Kiwagi

1 Answers1