I have a table with a date field, and I do a simple sort and here are the results:
For some reason 24-SEP-07 always comes up first. When I convert it to a 4 digit year it returns 0407. Whereas other dates, even dates in 2007, return the correct 4 digit year (2007).
Any idea why the year is not being converted correctly for this value?