How to transform a date into a ISO8601

Options
emvipy
emvipy Member ✭
in ? Transforming data

Hi there,
I need to transform a date to ISO8601 format but if I use "c" in transform timestamp the resulting format is this:
2023-09-04T00:00:00+00:00
and I need this one:
2023-09-04-04T00:00:00Z

How can I do it?
Thanks!

· Share on Twitter

Best Answer

  • Ray Deck
    Ray Deck Trusted Xano Expert ✭✭✭
    Answer ✓
    Options

    That you get is valid ISO 8601. Z is a shortcut for “Zulu time” which is GMT. But maybe you need this exact format because it’s what your consumer requires! I’d use the c, then split the result on “+” then apply the first filter then apply the concat filter with a value of Z.

    · Share on Twitter

Categories