Forum Discussion

vipulk10's avatar
vipulk10
New Contributor III
8 years ago

Get offset from a date

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...
mthirani's avatar
mthirani
Employee
8 years ago
Copy LinkReport

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

  • vipulk10's avatar
    vipulk10
    New Contributor III
    8 years ago
    Copy LinkReport

    so is there any workaround to get this??

    • cstewart's avatar
      cstewart
      Former Employee
      8 years ago
      Copy LinkReport

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

      • del's avatar
        del
        Contributor III
        8 years ago
        Copy LinkReport

        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.