I need help on sql where i can convert Date and Time (including day light savings) to GMT .
In my table, I have different City’s like Dallas ,Los Angles, New York , Tokyo etc. for this city’s the time is recorded based on their respective local timings. so I need to convert to them to GMT.
Format of my fields..
I'm not sure about your data, but assuming you have the time as TIME WITH TIMEZONE you can build a timestamp with time zone and do something like:
MY_TIMESTAMP_WITH_TIME_ZONE AT TIME ZONE INTERVAL '00:00' HOUR TO MINUTE