Quote Originally Posted by jmodic
Something does not mach here! You said the date enetered was something like '27/01/20055' and that query on that value returned '27/01/5555'. However your dump shows a perfectly normal date that does not match any of those two - it represents the date 17/02/2004 00:00:00 (dd/mm/yyyy hh24:mi:ss). So neither the day nor month portion match any of your quoted dates and the year in this dump is perfectly normal 2004. !?
Like I mentionned above we changed the value of the column.