R
rayherring
Guest
For my SOAP requests to 3rd party I have to format the datetime as datetime-tz for UTC, to do this I am pulling a datetime-tz out of the database in UTC+8 (Western Australian Standard Time) then converting it to UTC by doing DATETIME-TZ(datefield, 00). This works perfectly (though when I do 1 of the datetime-tz requests I have to strip out the +HH:MM and change it to a "Z" but that isn't really a problem, however, when the response comes back from the 3rd party it has an 'AuthDateTime' field which is also in UTC. I have checked the original SOAP response XML that I got back (before the parser ever gets its grubby little mits on it to put the XML into a dataset) and what I am getting back is the following: 2016-06-13T05:17:33.000632 When I check the resultant temp-table after the parser has done its job, it comes back with (and this is what also gets stored in the DB: 16/06/2016 05:17:33.000+08:00 This is a bit undesirable (I cannot change how the 3rd party is returning it, maybe their format is too much for the parser...) Is there any easy way to make it so that when the temp-table (and the DB) see it, it has +00:00 on it instead?
Continue reading...
Continue reading...