Save timestamp in database

Save timestamp in database

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

05-03-2018, 09:50 AM

(05-03-2018, 09:00 AM)InsiteFX Wrote: Here is a Mind Blowing article on it.

Today I learned about MySQL and timezones

Hope that helps.

The best site i'v ever seen in all site
Thank you
And new problem is
I need timestamp in database when user add data to database and show it in user's app according relate time zone
I save UNIX_TIMESTAMP in database with time zone +00:00 and use output in app with different time zone
Is it right?

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