Use Date to query oracle db error

[#1]

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

[#2 · Accepted solution]

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

[#3]

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

[#4]

It depends on what datetime format is specified in table definition.

I`m glad it helped.

Regards

Tomas