Sql command issue in qlikview

[bhavvibudagam]

Hi,

I have the below script.When I reload I am getting the error as shown in the image.Please help me to do

ODBC CONNECT TO [PDRMSBKUP;DBQ=PDRMSBKUP ] (XUserId is KMAKLZVNTTcKGYdNSDdcC, XPassword is bDaIOZVNTTcKGYdNSDdKL);

TTTT:

LOAD *;

SQL SELECT *

FROM LEADS.LWMAIN WHERE MODTIME >= $(vPDRMSBKUP_LWMAIN_RecentDate) ;

Thanks !

[adamdavi3s]

just convert it to decimal.

In tSQL this is select convert(decimal(12,4),getdate()) but I suspect that oracle is different

[bhavvibudagam]

ODBC CONNECT TO [PDRMSBKUP;DBQ=PDRMSBKUP ] (XUserId is KMAKLZVNTTcKGYdNSDdcC, XPassword is bDaIOZVNTTcKGYdNSDdKL);

This is the connection which we have used can you please tell me in oracle also

[adamdavi3s]

You probably don't want to go sharing your connection string on the web

It is of no use to us anyway

Can I suggest that you google the issue as it would appear to be an ORACLE issue rather than a qlik one, please see my message below for a pointer in the right direction!

[kaushiknsolanki]

Hi,

Try this,

SQL SELECT *

FROM LEADS.LWMAIN WHERE MODTIME >= TO_DATE('$(vPDRMSBKUP_LWMAIN_RecentDate)', 'DD/MM/YYYY hh:mm:ss TT');

Regards,

Kaushik Solanki