MYSQL Convert TimeZone | Local Time Zone

How to Convert the DATE TIME column to local time zone ?

In mysql the function CONVERT_TZ (, <>,<), converting a time zone from default to new / local zone.

Movers in Dubai
| Check Responsive site

Example :
Change to IST from Default.

convert_tz(order_date, ‘+00:00’ , ‘+05:30’)

Advertisements