My shop like many I'm told in the IBM i world uses numeric dates and times.
Dates are stored in 8 zoned or 9 packed numeric fields in YYYYMMDD format.
Times in a 6 zoned HHMMSS format. I'm thinking about creating a few UDFs so
that I can more easily convert them to SQL dates. Then I started thinking
that this is probably a very common problem and there is probably a solution
out there already. Does anyone know of one?
If not maybe I'll make them and put the code on github or something.
I'm thining of three functions:
1. numeric date and time in, timestamp out
2. numeric date in, date out
3. numeric time in, time out