xxxxxxxxxx
/*'EST' is always -5:00 from UTC; IN MAINE WITH DST, WE USE THIS IN THE WINTER*/
/*'EDT' is always -4:00 from UTC; IN MAINE WITH DST, WE USE THIS IN THE SUMMER*/
tzoneu2s(t1.DATE_TIME,'EST') FORMAT=DATETIME20. as DATE_TIME_EST ,
tzoneu2s(t1.DATE_TIME,'EDT') FORMAT=DATETIME20. as DATE_TIME_EDT ,
/*'America/New_York','US/Eastern'*/
/**/
/*These two are the same, they incorporate daylights savings*/
/*They are 4 (EDT) or 5 (EST) hours behind depending on the time of year*/
tzoneu2s(t1.DATE_TIME,'America/New_York') FORMAT=DATETIME20. as DATE_TIME_AMER_NY ,
tzoneu2s(t1.DATE_TIME,'US/Eastern') FORMAT=DATETIME20. as DATE_TIME_US_EAST ,