Originally posted by: SystemAdmin

another basic question...

Recently added a date column to a table (prior to this time there were no date columns in my tables)

The DB Interface Designer build the related tree and I populated the date in the map.

The DBID defined the column as "ccyy-mm-dd hh:mm:ss" so I used the "currentdatetime()". The output looks like "2004-07-22 16:33:19". Which seems to match the definition but this error is generated....

.....column DATE.
ORA-01861: literal does not match format string

What am I doing wrong?

jvanboga
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

it might be worthwhile checking the delimiters and terminators you are using - have these changed at all ?
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

No, I kept the DBID default delimiters which have been working for both populating rows via a map and SQL Loader. However, until we added the date column all previous columns were loaded as Varchar.

jvanboga
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Resolved.... used SQLLoader and added syntax below to control file where ever the date fields were added.

Date "YYYY-MM-DD HH24:MI:SS" TERMINATED BY "|" OPTIONALLY ENCLOSED BY'~'

jvanboga
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender