Search code examples
datetimedataweave

dataweave transformation DateTime : Unable to obtain ZonedDateTime from TemporalAccessor

With this command in Dataweave 2.0 :

"08:05:30" as DateTime{format: "hh:mm:ss"} as String {format: "hh:mm:ss"}

I have this error :

Unable to obtain ZonedDateTime from TemporalAccessor

How to solve it ? My whole problem is to transform :

"Wed Oct 18 2023 08:05:30 GMT-0000 (GMT)"

to

"2012-10-11T12:30:40-03:00"

I tried :

"Wed Oct 18 2023 08:05:30 GMT-0000 (GMT)" as DateTime{format: 'E MMM dd yyyy hh:mm:ss zXX O'} as String {format: "yyyy-MM-dd'T'hh:mm:ssO"}

Thank you so much !

Solution

  • You are trying to convert a string that contains apparently a time to a Date Time plus Time zone type. Because the input misses the date and time zone the transformation will fail.

    Instead convert it to a LocalTime (ie a time without a timezone):

    "08:05:30" as LocalTime{format: "HH:mm:ss"} as String {format: "HH:mm:ss"}

    Note that I used HH for the 24 hs format. Using hh is for the 12 hs am/pm format.

    By the way, it is fine if this is just an example but converting to String at the end is just returning a string equal to the input. Not sure if that is intentional.