EST timezone in mysql query code example

Example 1: mysql select utc time in eastern time

CONVERT_TZ(created_at,'+00:00','-04:00')

Example 2: mysql datetime with timezone offset

INSERT INTO table_name  CONVERT_TZ(SUBSTR('2011-10-04 12:58:36 -0600',1,19),'+00:00',SUBSTR('2011-10-04 12:58:36 -0600',20));