I have a xquery where I am mapping as below:
<ns0:REV_DTE>{data(fn-bea:dateTime-to-string-with-format('MMM-dd-yyyy HH:mm:ss',fn:adjust-dateTime-to-timezone(fn-bea:dateTime-from-string-with-format('MMM-dd-yyyy HH:mm:ss',$ns1:IssueDate))))}</ns0:REV_DTE>
I want the result as below:
If IssueDate = Feb-09-2017 11:13:00 then the converted date should be Feb-09-2017 16:13:00 irrespective of when I am doing the conversion. Currently, if I run the piece of code today, I get back Feb-09-2017 15:13:00 since the time difference between EST and UTC now is 4 hours where as on Feb-09 the time difference was 5 hours.
Basically what I want is the time to adjust based on the datetime passed in and not on the current date. I hope my question makes sense.