Selecting eastern standard time in mysql code example

Example 1: mysql select utc time in eastern time

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

Example 2: how to set global time_zone in mysql

SET GLOBAL time_zone = timezone;

eg: SET GLOBAL time_zone = 'Asia/Kolkata';