Re: UDFs for Date conversions

[Raul Jager <raul@xxxxxxxxxx>]

SQL and RPG already have build in functions for that purpose.


On 09/15/2017 04:49 PM, Mark Bonges wrote:
> 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
>
> Thanks!
> Mark


-- Este e-mail fue enviado desde el Mail Server del diario ABC Color -- 
            -- Verificado por Anti-Virus Corporativo Symantec --