select query returns empty table

Shikhashah · #1 (**permalink**) 01-30-12, 05:39

I am trying to fetch some records from a table using

Quote:

select * from web_log where log_date = to_date('30-Jan-2012','dd-mon-yyyy')

it is working fine but returns an empty table however there is value in table.
It returns row if I query

Quote:

select max(log_date) from web_log

result- 30-JAN-12

can anybody have solution?

shammat · #2 (**permalink**) 01-30-12, 05:52

Please show us the result of:

Code:

SELECT to_char(max(log_date), 'dd-mon-yyyy'))
FROM web_log

My gues is, that the max date you are seeing is actually 30-JAN-1912

Littlefoot · #3 (**permalink**) 01-30-12, 06:16

My guess is that LOG_DATE contains time component (i.e. '30-jan-2012' is, actually, something like '30-jan-2012 13:23:22').

So, what happens if you try

Code:

select *
from web_log
where trunc(log_date) = to_date('30-jan-2012', 'dd-mon-yyyy')

Shikhashah · #4 (**permalink**) 01-30-12, 06:59

yes it worked

shammat · #5 (**permalink**) 01-30-12, 07:12

Quote:

Originally Posted by Littlefoot

My guess is that LOG_DATE contains time component (i.e. '30-jan-2012' is, actually, something like '30-jan-2012 13:23:22').

Very good point. Should have thought of that myself

Internet Services

Web Development

Digital Marketing

Consumer Tech