Get offset from a date

Question

hi all,
i have been trying to get offset in a date format. i m using
toLocaleDateTimeString({“timeZone”:$dealerTimeZone, “format”:“yyyy-MM-dd'T'HH:mm:ss Z”})
since Z denotes offset, but its not showing offset in output ie -0800 or something like this.Please help

del · Answer

I think vipulk10 is using the Z per the joda DateTimeFormat per the URL referenced in the SnapLogic Documentation for toLocaleDateTimeString - DateTimeFormat (Joda-Time 2.11.1 API).  If the SnapLogic method utilized the joda formatting entirely, the Z would result in the offset value “-0800”.  While ‘Z’ (in single quotes) would result in the string “Z” to represent GMT if desired.

mthirani · Answer

Z specifies the UTC or Zulu Time Zone (Zero hour offset). It will not be showing output like -0800 as mentioned.

vipulk10 · Answer

so is there any workaround to get this??

cstewart · Answer

the Z indicates there is no time offset from GMT.  Where do you want an offset from?

vipulk10 · Answer

del you are correct, but i am not getting the desired response . currently I am using
toLocaleDateTimeString({“timeZone”:$dealerTimeZone, “format”:“yyyy-MM-dd’T’HH:mm:ss Z”})
Z is not parsed correctly and offset is not shown in the output

Forum Discussion

Get offset from a date

Recent Discussions

Pagination and nextCursor in header

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?