How save timestamp according to Asia timezone

How save timestamp according to Asia timezone

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

02-14-2019, 01:20 PM

Hi
I receive timestamp base of UTC and save it into database
Now i need report all data example between 2:30 to 14:43
And i am Tehran with GMT +3:50
Can i save timestamp base of Asia/Tehran timezone or i can only get their base of my favorite timezone?
Can i set timezone to Asia/Tehran on mysql when i use SELECT command?
Thanks

Messages In This Thread

How save timestamp according to Asia timezone - by omid_student - 02-14-2019, 01:20 PM

RE: How save timestamp according to Asia timezone - by KoRsar4eg - 02-14-2019, 03:02 PM

RE: How save timestamp according to Asia timezone - by omid_student - 02-15-2019, 05:24 AM

RE: How save timestamp according to Asia timezone - by rmcdahal - 02-14-2019, 08:51 PM

RE: How save timestamp according to Asia timezone - by omid_student - 02-15-2019, 05:24 AM

RE: How save timestamp according to Asia timezone - by omid_student - 02-16-2019, 04:51 AM

RE: How save timestamp according to Asia timezone - by omid_student - 02-16-2019, 05:33 AM