Save timestamp in database

Save timestamp in database

omid_student
Omid Aghakhani
Posts: 381
Threads: 119
Joined: May 2015
Reputation: 0

05-03-2018, 06:01 AM

Hi
I can save current timestamp with UNIX_TIMESTAMP function in mysql example 1525352382
My project is international and for each country,i have to show time according timezone it
In php i can set timezone to current country and get time from timestamp
But it is important that what is mysql timezone for base?
Example is it London or other?

Messages In This Thread

Save timestamp in database - by omid_student - 05-03-2018, 06:01 AM

RE: Save timestamp in database - by InsiteFX - 05-03-2018, 09:00 AM

RE: Save timestamp in database - by omid_student - 05-03-2018, 09:50 AM

RE: Save timestamp in database - by InsiteFX - 05-03-2018, 11:12 AM

RE: Save timestamp in database - by omid_student - 05-03-2018, 11:52 AM

RE: Save timestamp in database - by InsiteFX - 05-04-2018, 03:58 AM

RE: Save timestamp in database - by omid_student - 05-04-2018, 07:15 AM