I a table with a few rows with wrong year date.
The format from the date is: "MM/DD/YYYY"
The incorrect year it's 1933 and the most appropriate one is 2011.
How do you alter the year with SQL in Interbase???
I discovered I possibly could perform a CDate with other people DB but on Interbase I did not find anything yet.
Something along wrinkles might work. Assumes that dates in 1933 have to be up-to-date. CAST(), EXTRACT(), and also the concatenation operator ('') are standard SQL.
UPDATE yourtablename SET date_column = CAST('2011-' EXTRACT(month from date_column) '-' EXTRACT(day from date_column) as DATE) WHERE date_column BETWEEN '1933-01-01' and '1933-12-31'
Chances are good that without having a cheque constraint on that column, more 1933 dates can have up eventually.