| Re: Converting Date data in SQL Loader [message #368277] |
Wed, 25 October 2000 09:02 |
Shanthi
Messages: 8
Registered: October 2000
|
Junior Member |
|
|
Thanks. It Works
I have tried the combinations of substr/replace etc, but I haven't realized my mistake until I saw your posting. I forgot to place a semicolon( ":") before a variable name
,vestek_change_date "to_date(replace(vestek_change_date,substr(vestek_change_date,-6,4),''),'MON DD YYY
Y hh:mi:ssAM')"
Since the SQLLoader messages are not user friendly
Record 1: Rejected - Error on table ACCOUNT, column VESTEK_CHANGE_DATE.
ORA-00984: column not allowed here
, I never realized it. Thought something wrong with the logic I was using, wasted whole day yesterday. Thanks,
Shanthi
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
