Re: Create a field in AS/400 queries

[nickmart@xxxxxxxxxxxxxxx]

(year * 10000) + (month * 100) + (day * 1)

Nick Mart



> Hello
>
>
>
> I have tree different fields in AS/400
>
> Year
>
> Month
>
> Day
>
>
>
> So I have this:
>
> 2007
>
> 09
>
> 12
>
>
>
> And I have to transform those tree fields in 2007-09-12. My problem is
> that I can't concatenate because those fields are numbers.
>
>
>
> I can I transform those number into a date?
>
>
>
>
>
> Regards,
>
> Marco
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.