>Date: Tue, 19 Oct 1999 15:57:16 -0500 >From: "Stone, Brad V (TC OASIS)" <firstname.lastname@example.org> > >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: email@example.com +---
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.