Mysql: Change Timezone Per Query -


i want change timezone while query executing.

like calculating attendance , store timestamp in attendance table. expected check-in time of employee stored in employee table , office timezone stored in office table, timezone can differ office office. office 1 can have different timezone office 2.

so functions date_format( from_unixtime()) should work each office's timezone.

you should take @ mysql function:

convert_tz


Comments

Popular posts from this blog

Capture and play voice with Asterisk ARI -

java - Why database contraints in HSQLDB are only checked during a commit when using transactions in Hibernate? -

visual studio - Installing Packages through Nuget - "Central Directory corrupt" -