Hi
Is there a way to convert Epoch time to standard date time format ??
something like this??
select ‘1609999200000’,convert_tz(‘1609999200000’,‘GMT’,‘EST’);
Yes. See the documentation for FROM_UNIXTIME():
See also its companion function UNIX_TIMESTAMP():