var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: select query returns empty table
I am trying to fetch some records from a table using
it is working fine but returns an empty table however there is value in table.
select * from web_log where log_date = to_date('30-Jan-2012','dd-mon-yyyy')
It returns row if I query
select max(log_date) from web_log
can anybody have solution?
Please show us the result of:
My gues is, that the max date you are seeing is actually 30-JAN-1912
SELECT to_char(max(log_date), 'dd-mon-yyyy'))
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
where trunc(log_date) = to_date('30-jan-2012', 'dd-mon-yyyy')
yes it worked
Very good point. Should have thought of that myself
Originally Posted by Littlefoot
Tags for this Thread