Converting Time zone with day light saving
I am trying to do a simple conversion of time zones of a datetime column from UTC to CST and EST. For some reason, I am getting error in this formula:
CONVERT_TZ(`DateTimecolumn`, 'utc', 'cst')
I also tried CDT instead of CST but getting error. I need something which works for time zone conversion as well as day light saving.