Hi
In my oracle table in the date field if the day is over 12 then for some reason the day and month is the wrong way around, from previous data imports to the table
So for example
09/02/1970 is displaying as 02/09/1970 (UK date format)
but if the date is 22/02/1970 this is showing correctly in the database as the day was over 12.
Without having to resort in trying to load the data into the database again could I use PL/SSQL to check if a day is 12 or below and switch the values for the day and the month keeping the year the same