Solved: Re: missing expression from SQL - Qlik Community

markgraham123 · ‎2015-10-29

Hi all,

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,

SQL SELECT

*

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.

maxgro · ‎2015-10-29

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')

or

WHERE LAST_UPDATE_DATETIME > to_date('28/10/2015 00:00:00', 'DD/MM/YYYY HH:MI:SS')

sinanozdemir · ‎2015-10-29

Are you using SQL Server? If so, the query should be like the below:

SQL SELECT

*

FROM Table WHERE LAST_UPDATE_DATETIME >='2015-10-28';

maxgro · ‎2015-10-29

The function (datetime, ....) and format ('10/28/2015') after the SQL depends on the database, not QlikView;

what's the database?

markgraham123 · ‎2015-10-29

Maxgro,

It's SQL

markgraham123 · ‎2015-10-29

I tried that too bro.

But no luck, same error.

handry_orozco · ‎2015-10-29

Try,

Select *

From Table Where DateTime(Cast(Last_Uptdate_Datetime) As Date) >= '10/28/2015'

Bye

markgraham123 · ‎2015-10-29

SQL##f - SqlState: S1000, ErrorCode: 936, ErrorMsg: [Oracle][ODBC][Ora]ORA-00936: missing expression

markgraham123 · ‎2015-10-29

SQL##f - SqlState: S1000, ErrorCode: 936, ErrorMsg: [Oracle][ODBC][Ora]ORA-00936: missing expression

Report Inappropriate Content · ‎2015-10-29

Graham,

Can you add Attribute names after your select statement & check this link.

Thanks

Brad.

markgraham123 · ‎2015-10-29

I tried that after checking that thread this morning
but no progress