Re: DB2 numeric to date conversion

[Jon Paris <jon.paris@xxxxxxxxxxxxxx>]

It is trivial in RPG so I'd probably wrapper a simple piece of RPG code and call it.


Jon P.

> On Nov 6, 2023, at 11:45 AM, Dave <dfx1@xxxxxxxxxxxxxx> wrote:
>
> Hello,
>
> I came up with this in order to convert a 8,0 numeric field to a date that
> seems to work. Format is YYYYMMDD so it would be a bit different for most
> of you.
> Can anyone suggest something to make it easier on the eye? Thanks!
>
> select
>
>  date('0001-01-01') +
> (int(myDate/10000) - 1) years +
> (int(mod(myDate , 10000)/100) - 1)  months +
> (mod(mod(myDate , 10000), 100) - 1) days
> from myFile
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.