i work on existing project stores dates mysql db. dates stored utc since users far in gtm+0 , no conversion needed.
i need modify code users other time zones can use system. users choose timezone when register system, have table holding timezone each user.
i know can use convert_tz() when extract , store dates, means go through queries , add function.
when do: set @@session.time_zone:='+7:00'; select now(); result changes timezone variable.
when do: set @@session.time_zone:='+7:00'; select mydate mytable; result stays same, returning stored in db.
is there way can change connection string or there session variable can use affect queries without having add convert_tz every single query?
edit: not duplicate of should use field 'datetime' or 'timestamp'? since using timestamp means need change date field in db, while try change more global not have massive changes db fields or code.
