I have a prod issue where a code segment has the date comparision to input date and it failed on the executionl
I have table A with column birth_date as defined as date
in the code segment we do
birth_date <= '01-MAY-2006'
the value for birthdate is 01-MAY-2006 but has time component 14:05:26
how do I see in the table what are the rows that has date in date time format?
and then I want to fix the problem..
first to find the length of the column I did
select * from tableA where length(birth_date) > 10 , I got none I hope to see all the time fields showing up..
Any help here please..