I'm running a my sql query
and in a date field a date in the past is stored say 1980-01-01

how do I change the the year form 1980 to the current year 2006 within the query. I don't want to update the table value.

any help is great