topic Re: sql Query issue in QlikView

sql Query issue

krishnacbe — Thu, 30 Aug 2012 11:45:52 GMT

I have used below query

select * from exposure where Createtime>'8/30/2012 12:30:04';

Result is

But the above row should not be fetched.

Thanks in advance.

Regards

Krishna.S

Re: sql Query issue

jagannalla — Thu, 30 Aug 2012 11:53:08 GMT

First run this query in sql and check. Otherwise use this code:

Load *

where Date(Createtime,'M/DD/YYYY hh:mm:ss') > '8/30/2012 12:30:04'

;

Select * from exposure;

Cheers!!

Jagan

Re: sql Query issue

chematos — Thu, 30 Aug 2012 14:34:30 GMT

Try with spaces between Createtime and '8/30/2012 12:30:04';

select * from exposure where Createtime > '8/30/2012 12:30:04';

Regards

Re: sql Query issue

teempi — Fri, 31 Aug 2012 08:52:03 GMT

Hey,

Also make sure there's no fraction in your timestamp. Try something like > '8/30/2012 12:30:04.999' or >'8/30/2012 12:30:05'

-Teemu

Re: sql Query issue

rbecher — Fri, 31 Aug 2012 08:59:49 GMT

Hi Krishna,

I don't know which db vendor you have. Usually a TO_DATE function (to convert the date string into the datetime data format) in the where clause would help.

- Ralf