Oracle query not displaying date properly
In Oracle, there is a column(dateColumn) in a table with column type = DATE and the value for a particular record is showing as '10/03/2010' when I do a `select * from table.`
Now, when I do:

    select * from table where dateColumn < '01-JAN-11'

Nothing shows up. When I do:

    select * from table where dateColumn > '01-JAN-11'

The record shows up.
Why is this behaving this way? 10/03/2010 is 10th MArch 2010 so clearly that is < 01 Jan 2011.
Oracle query not displaying date properly
===

In Oracle, there is a column(dateColumn) in a table with column type = DATE and the value for a particular record is showing as '10/03/2010' when I do a `select * from table.`
Now, when I do:

    select * from table where dateColumn < '01-JAN-11'

Nothing shows up. When I do:

    select * from table where dateColumn > '01-JAN-11'

The record shows up.
Why is this behaving this way? 10/03/2010 is 10th MArch 2010 so clearly that is < 01 Jan 2011.