Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
Oracle DB SyncDate field format:
DD/MM/YYYY hh:mm:ss
SQL Query:
SQL SELECT *
FROM DB."Table_Name" WHERE SYNC_DATE = '05/04/2011 00:08:13'
error:
ErrorSource: OraOLEDB, ErrorMsg: ORA-01861: literal does not match format string
SQL SELECT *
FROM DB."Table_Name" WHERE SYNC_DATE = '05/04/2011 00:08:13'
Any body know why, it worked before in QV 9, after switch desktop to 10 I got this error.
thanks
Michiel
Hi,
I got a similar problem few days ago.
Try using oracle TO_DATE function in WHERE clause. In my case it helped:).
SQL SELECT *
FROM CC."RP_RAWDATA_HEADER" WHERE SYNC_DATE = TO_DATE('05/04/2011 00:08:13','MM/DD/YYYY hh:mm:ss')
Tomas
Hi,
I got a similar problem few days ago.
Try using oracle TO_DATE function in WHERE clause. In my case it helped:).
SQL SELECT *
FROM CC."RP_RAWDATA_HEADER" WHERE SYNC_DATE = TO_DATE('05/04/2011 00:08:13','MM/DD/YYYY hh:mm:ss')
Tomas
Hi,
It's the sollution for sure but the format string needed a small modification:
Final working string is:
'DD/MM/YYYY hh24:mi:ss'
Thanks!
Michiel
It depends on what datetime format is specified in table definition.
I`m glad it helped.
Regards
Tomas