Ray,
The pickwiki dateutility should do what you want (UD functionality
notwithstanding).
Deffun DateUtility(method,args)
isoDateTime = '20070623T00:00' ;* 2007-06-23T00:00Z, 07JUN23 etc.
internalDateTime = DateUtility('ParseISODateTime.local',isoDateTime)
crt internalDateTime<1>'D', internalDateTime<2>'MTS'
On a host machine with locale set to UTC-7 (PST) and with June being
within DLS start/stop parameters: (eg UTC-6) the program above will
output:
22 JUN 2007 18:00:00
Stuart.
>-----Original Message-----
>Sorry, I'm looking to convert a GMT date/time group that is DST-less
>and in Zulu-time to the local date/time (several timezones east and
>potentially shifted another hour by DST). The data is coming from a
>service provider and we have no control over the format. The data is
>sent as ISO8601 DTG's like: YYYY-MM-DDThh:mm:ss-00:00 (The time zone
>offset is always 00:00) and a minimal character format:
>YYYYMMDDHHMMSS, depending whether the transaction is being passed
>real-time or as part of a batch mode data file. The sub-string
>access is easy, it's the timezone/DST translation that I'm looking to
>do "The Right Way".
>The original data is archived, it's just that for integration with
>the existing dataset, and reporting purposes, the date/time needs to
>be converted into internal format in local time.
**********************************************************************
This email message and any files transmitted with it are confidential and
intended solely for the use of addressed recipient(s). If you have received
this communication in error, please reply to this e-mail to notify the sender
of its incorrect delivery and then delete it and your reply. It is your
responsibility to check this email and any attachments for viruses and defects
before opening or sending them on. Spotless collects information about you to
provide and market our services. For information about use, disclosure and
access, see our privacy policy at http://www.spotless.com.au
Please consider our environment before printing this email.
**********************************************************************
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
