How save timestamp according to Asia timezone |
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 (02-14-2019, 01:20 PM)omid_student Wrote: Hi 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
In CI4 there is options for timezone setting on
public $appTimezone = 'America/Chicago'; This may help, In CI3 in application/config.php date_default_timezone_set('America/Chicago');
(02-14-2019, 03:02 PM)KoRsar4eg Wrote:(02-14-2019, 01:20 PM)omid_student Wrote: Hi Hi I need set timezone in mysql and execute query $this->db->where("TIME_FORMAT(FROM_UNIXTIME(time),'%H:%i') >=", $from_time); Can i define timezone in FROM_UNIXTIME function?
|
Welcome Guest, Not a member yet? Register Sign In |