topic Re: to_date in qlikview in QlikView

to_date in qlikview

Mon, 21 Jul 2014 10:17:58 GMT

Hello everyone,

I would like to place on question.

I want to make a query on a oracle database with qlikview, but I have an error.

An example of what I am trying to do is this:

SELECT todate(sysdate,'DD-MM-YYYY') as "data" from dual;

This returns the error on the image attached.

*Error translation: the literal does not correspond to the character chain if the format SELECT...

If I run the line SELECT todate(sysdate) as "data" from dual; it works without a problem.

EDIT: I forgot to say that if I run the statement on sql developer it works...

Any ideas?

Thanks in advance!

vardhancse — Mon, 21 Jul 2014 10:22:53 GMT

The default date format might be SET DateFormat='MM/DD/YYYY';

Try to change and re run the script

Mon, 21 Jul 2014 10:29:35 GMT

With this line

SELECT todate(sysdate,'MM/DD/YYYY') as "data" from dual;

I get a new error: Not a valid month, probably because today is the 21st and on where is MM should be the value of the day...

But the formatting of the date should overwrite this...

I forgot to say on the top post that if I run the statement on sql developer it works...

aveeeeeee7en — Mon, 21 Jul 2014 10:35:56 GMT

Hi Ivo

Use To_Char instead of ToDate

SELECT to_char(sysdate,'MM/DD/YYYY') as "data" from dual;

Regards
Aviral Nag

ashfaq_haseeb — Mon, 21 Jul 2014 10:36:19 GMT

HI,

After making connecting string with Oracle database.

try below

SQL SELECT todate(sysdate,'DD-MM-YYYY') as "data" from dual;

Regards

ASHFAQ

Mon, 21 Jul 2014 10:45:27 GMT

It works with to_char.

Thanks!!