topic Use Date to query oracle db error in QlikView

Use Date to query oracle db error

Tue, 05 Apr 2011 14:33:44 GMT

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

Use Date to query oracle db error

Tue, 05 Apr 2011 15:10:13 GMT

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

Use Date to query oracle db error

Wed, 06 Apr 2011 07:36:59 GMT

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

Use Date to query oracle db error

Wed, 06 Apr 2011 07:46:55 GMT

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

I`m glad it helped.

Regards

Tomas