Discussion Board for collaboration on QlikView Scripting.
I'm trying to fetch the records which were greater than 10/28/2015 05:10:55 PM from SQL through qlikview script.
I have field "Last updated Date time" which holds that value.
But when i use,
FROM Table WHERE DATETIME(LAST_UPDATE_DATETIME) >='10/28/2015';
It's throwing "missing expression from SQL" error.
Can some one please help me to get into the right format.
Go to Solution.
Your error says you're using an Oracle database;
but in Oracle I don't find a datetime function SQL Functions
maybe this if LAST_.... is a date
WHERE LAST_UPDATE_DATETIME >= to_date('28/10/2015', 'DD/MM/YYYY')
WHERE LAST_UPDATE_DATETIME > to_date('28/10/2015 00:00:00', 'DD/MM/YYYY HH:MIS')
Are you using SQL Server? If so, the query should be like the below:
FROM Table WHERE LAST_UPDATE_DATETIME >='2015-10-28';
The function (datetime, ....) and format ('10/28/2015') after the SQL depends on the database, not QlikView;
what's the database?
I tried that too bro.
But no luck, same error.
From Table Where DateTime(Cast(Last_Uptdate_Datetime) As Date) >= '10/28/2015'
SQL##f - SqlState: S1000, ErrorCode: 936, ErrorMsg: [Oracle][ODBC][Ora]ORA-00936: missing expression
Can you add Attribute names after your select statement & check this link.
I tried that after checking that thread this morning but no progress