Archive2

Converting Timecolumn (not _time) from UTC to EST without impacting Daylight saving differences

Explorer

Hi,

I've 4 timestamp columns in an event which are in UTC but I need to convert it into EST. I can do it by subtracting 4 hrs now but when day light saving ON then that difference would be 5 hrs. So again I need to go and change the query manually. So is there anyway to do this conversion automatically when Day light saving ON/OFF?.

Thanks,

Tags (1)
0 Karma
Reply