Re: TIME opcode results in different countries?

[bmorris@xxxxxxxxxx]

>Date: Tue, 19 Oct 1999 15:57:16 -0500
>From: "Stone, Brad V (TC OASIS)" <bvstone@taylorcorp.com>
>
>If I use the TIME operation on a 14 digit field, here in the US, I get the
>following results just fine.  I get...
>>hhmmssmmddyyyy
>
>Now, if I do this is say, Italy, will the format be:
>hhmmssddmmyyyy?
> ...

Brad,
If you need to get the date in a consistent format, the best way to deal with
the date part of a numeric TIME result is to movel it to a date field using
*JOBRUN as the format.  Use the 12-digit form of TIME for this, since the job
date format refers to a 6-digit date.  If you do this, be sure to use MOVEL
since using MOVE with a Julian job format would produce incorrect results.

D           ds
d  t12            12s 0
d    td            6s 0   overlay(t12:7)
d  date     s       d     datfmt(*iso)
d  ddmmyyyy s      8s 0

 * Get date in job date format
C            time           t12
 * Convert to "real" date field
C   *jobrun  movel  td      date
 * Convert to numeric field in ddmmyyyy format
C   *EUR     movel  date    ddmmyyyy

I think it's V4R2 where you can put a date field directly in the result field of
TIME.

Barbara Morris


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---