sql Query issue

[krishnacbe]

Hi

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

[jagannalla]

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

[chematos]

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

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

Regards

[teempi]

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

[rbecher]

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