[Oracle][ODBC][Ora]ORA-01861: literal does not match format

[bgs_vb]

Hi,

I am getting following error, how to solve it.

J_Stage_PS_S_BUS_UNIT_RA_CRM..DRS_SRC_PS_BUS_UNIT_TBL_RA: [Oracle][ODBC][Ora]ORA-01861: literal does not match format string.

Regards,
Vindy

[rasi]

Hi

This error occurs when you mistyped the formats especially in your datetime. Post your SQL it will give us more info.

[Poornagirija]

HI,
If you are trying to populate otherthan date data type in Date field you will get these type of errors.

if you are trying to populate @date but with timestamp data type you will get these error.

[bgs_vb]

My SQL output is like this:

how do i solve this...i tried by adding various formats but still it shows the error.

J_Stage_PS_S_BUS_UNIT_RA_CRM..DRS_SRC_PS_BUS_UNIT_TBL_RA: [Oracle][ODBC][Ora]ORA-01861: literal does not match format string

J_Stage_PS_S_BUS_UNIT_RA_CRM..DRS_SRC_PS_BUS_UNIT_TBL_RA: SQLExecDirect: Error executing statement 'SELECT Ltrim(Rtrim(BUSINESS_UNIT)),Ltrim(Rtrim(DESCR)),Ltrim(Rtrim(DESCRSHORT)),Ltrim(Rtrim(CURRENCY_CD)),Ltrim(Rtrim(BUSINESS_UNIT_RSF)),PRINTER_ID,ROW_ADDED_DTTM,Ltrim(Rtrim(ROW_ADDED_OPRID)),ROW_LASTMANT_DTTM,Ltrim(Rtrim(ROW_LASTMANT_OPRID)),SYNCID,SYNCDTTM FROM SYSADM.PS_BUS_UNIT_TBL_RA WHERE ROW_LASTMANT_DTTM > '1753-01-01 00:00:00'
OR ROW_LASTMANT_DTTM IS NULL '. See following database message for details.

Attempting to Cleanup after ABORT raised in stage J_Stage_PS_S_BUS_UNIT_RA_CRM..DRS_SRC_PS_BUS_UNIT_TBL_RA

[Poornagirija]

HI, :D
I guess the problem is with the ROW_LASTMANT_DTTM field.
You are trying to do some comparison.
Check the data type of those fields.

If ROW_LASTMANT_DTTM is a date data type and your comparing that with timestamp then it will give that error.

Otherwise make ur query like the following for your date datatype
TO_CHAR(Tablename.ROW_LASTMANT_DTTM , 'YYYY-MM-DD HH24:MI:SS')

Hope this will help you....