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
[Oracle][ODBC][Ora]ORA-01861: literal does not match format
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 65
- Joined: Fri Nov 19, 2004 12:00 am
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
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
-
- Participant
- Posts: 65
- Joined: Fri Nov 19, 2004 12:00 am
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....
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....
With Regards,
Poornagirija.
"Don't limit your challenges - challenge your limits"
Poornagirija.
"Don't limit your challenges - challenge your limits"