Using DatePicker for Oracle DB

Database Support
#1

Hello Helical Insight,

I am using Helical Insight 4.0. When I am using date filter on the dashboard for Oracle database, I am getting an SQL Error: string literal not matching. It is working at the report level. Please help.

Thanks,
Kajipe.

#2

Hello Kajipe,

This is happening because the format of the date time variable at the dashboard level is not the same as expected by Oracle DB.

For the date picker to work with Oracle DB, use the following settings:

Display: YYYY-MM-DD

Value: YYYY-MM-DD HH:mm:ss

image

Please note that Oracle accepts dates in datetime format only (as a timestamp). Hence, value is to be passed as a datetime.

Thanks,
Helical Insight.