Re: Converting ISO dates to Timestamp format?

Add a substring to the following to extract the correct values from your
string?

timestamp(date('2018-03-07'),time('23:07:56'))





From: Bradley Stone <bvstone@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 03/16/2018 09:12 AM
Subject: Converting ISO dates to Timestamp format?
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Are there any SQL functions that can take an ISO data like:

2018-03-07T23:07:56Z

And convert this into a timestamp when inserting into a PF?

Bradley V. Stone
www.bvstools.com
MAILTOOL Benefit #13 <https://www.bvstools.com/mailtool.html>: The ability
to use an IFS stream file as the body of the email (either text or html).