• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How save timestamp according to Asia timezone

#2
(02-14-2019, 01:20 PM)omid_student Wrote: 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

Hi, not sure is that what are you asking, but you can use mysql date_add and date_sub functions. 

https://dev.mysql.com/doc/refman/5.5/en/...n_date-add
https://dev.mysql.com/doc/refman/5.5/en/...n_date-sub
Reply


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

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.