Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
markgraham123
Specialist
Specialist

missing expression from SQL

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.

38 Replies
markgraham123
Specialist
Specialist
Author

So, is there a way we can synamically say that it is AM or PM?

sinanozdemir
Specialist III
Specialist III

TO_CHAR(LAST_UPDATE_DATETIME, 'DD/MM/YYYY HH:MI:SS AM') should print the date with time stamp appending AM/PM at the end.

chancekbarkley
Partner - Contributor III
Partner - Contributor III

In Oracle that is just a placeholder.

markgraham123
Specialist
Specialist
Author

Sinan,

So, AM is just the keyword which makes the data base to check but not like we were restrictingit to only "AM".

sinanozdemir
Specialist III
Specialist III

That's correct.

markgraham123
Specialist
Specialist
Author

Sinan,

I really thank you for your help.

markgraham123
Specialist
Specialist
Author

Hi Chance,

I really appreciate you help.

You guys are so helpful.

Thank you again

sinanozdemir
Specialist III
Specialist III

You are welcome.