my flatfile date looks like this: 2002/01/01 00
it is currently in EST time.
I need to load it as GMT time.
Since GMT never has daylight-savings, it is not as easy as just adding 5 hours (could be 4 or 5 hours).

I wanted to use the NEW_TIME function in my control file to do this.
My old control file to just load the date is (edited meaningless params):
OPTIONS
( SKIP = 1,
)
LOAD DATA
APPEND
INTO TABLE temp_weather_data
FIELDS TERMINATED BY '\t'
(
station_code CHAR,
dummy1 FILLER,
RDNG_DT DATE 'yyyy/mm/dd HH24',
TEMP_NBR integer external
)

I tried editing the date line to look like this:
RDNG_DT new_time(DATE 'yyyy/mm/dd HH24',EST, GMT),

any suggestions? that didn't work above to change to GMT


thanks.