I've probably asked this before, but I can't remember the answer!
One can use the DECIMAL function to convert a date to a decimal.
For instance
values decimal(current_date)
returns 20080528.
Is there an easy way to convert the decimal value back to a date?
I can't use DATE(<decimal-value>) because it expects the decimal value to
be
the number of days since Jan 1, 0001.
I'm sure I could write a function to do what I need, but I don't want to
waste my time if it already exists.
DB2/LUW 9.5.
Thanks,
Frank
