posted 14 years ago
Hi,
I have a table here which has values of year in the yy format. The column itself is an int.
Now, there is a need to convert the values into yyyy format. So for ex. 12 will become 2012. 1 will become 2001.
I looked at convert and decode functions, but I am not sure if that will help. Could you please guide me on how I could do this on mysql ?
thanks,
MA