missing expression from SQL

[markgraham123]

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.

[markgraham123]

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

[sinanozdemir]

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]

In Oracle that is just a placeholder.

[markgraham123]

Sinan,

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

[sinanozdemir]

That's correct.

[sinanozdemir]

Here is a link for you:

How to represent time format AM/PM in Oracle S... | Oracle Community

[markgraham123]

Sinan,

I really thank you for your help.

[markgraham123]

Hi Chance,

I really appreciate you help.

You guys are so helpful.

Thank you again

[sinanozdemir]

You are welcome.