-
changing date from EST to GMT in sqlldr script
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.
- Cookies
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|