Posted: Tue Dec 13, 2022 1:14 pm Post subject: Invalid format: "2012-10-19T12:49:18'Z" is malform
Acolyte
Joined: 12 Feb 2015 Posts: 66 Location: Canada, QC
SET rMsg.EventTimeStamp = CAST(CURRENT_GMTTIMESTAMP AS CHARACTER);
SET rMsg.EventTimeStamp = SUBSTRING (rMsg.EventTimeStamp FROM 15 FOR 10)||'T'|| SUBSTRING (rMsg.EventTimeStamp FROM 26 FOR 12 )||'Z';
my output is 2012-10-19T08:28:30.862Z in this format, sometime it caught up with below and gives me Invalid format: "2012-10-19T12:49:18'Z" is malformed at "'Z"
2012-10-19T08:28:31'Z
<rMsg>
<EventTimeStamp>2012-10-19T08:28:30.862Z</EventTimeStamp>
<rMsg> -- This is Good
<rMsg>
<EventTimeStamp>2012-10-19T08:28:31'Z</EventTimeStamp>
<rMsg> -- This is Invalid
Thanks in Advance if you have any suggestion please suggest for this issue.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum