functions to parse date, time and datetime with given schema

[jonathanlukas]

Is your feature request related to a problem? Please describe.

No need for a workaround like this: https://camunda.github.io/feel-scala/docs/learn/samples/temporal-samples/#change-the-format-of-dates

Describe the solution you'd like

We would like to have a feel function that parses a string to a date, time or datetime with a given schema.

Example: date("18.01.2024","dd.MM.yyyy")

Related issues

• Camunda Jira FR: https://jira.camunda.com/browse/SUPPORT-20156

[bastiankoerber]

we have another customer / partner who is requesting this feature.
He wants to use it in our connector templates:

If we would have this feature in place, he could use a custom template + REST Connector.

Right now, we are forcing him to fork our REST Connector and add custom changes (which is not ideal).

Context:

Using the feel function now() produces serialized json for the rest connector that looks like 2024-03-11T16:38:33Z[GMT]" and Azure eventgrid won’t consume the timezone portion of that ([GMT]). It requires an iso date-time string in zulu time, without timezone, like this: “2024-03-11T16:38:33Z”
Really there’s 2 potential issues with getting a timestamp

1. Azure Event grid requires that the “eventTime” field of an event message contains a time expressed in UTC, but there’s no way to specify the timezone/offset in which you want to express a timestamp. By happy coincidence, the FEEL now() function seems to be producing a UTC timestamp, but this is an undocumented feature that might happen to be because of a setting on the cluster, but certainly not something I can depend on in perpetuity.
2. The timezone info is expressed in the format string, and there’s no way to specify this.

[skayliu]

And need parse timestamp with given format too , as described I got a timestamp value of 1686327521524 or 1686327521, I want to get the datetime of 2023-06-10 00:18:41.524 or 2023-06-10 00:18:41 so that I can insert the datetime into mysql table, the format is sql type as yyyy-MM-dd HH:mm:ss.SSS or yyyy-MM-dd HH:mm:ss.

And change the existing format to another like date("18.01.2024","dd.MM.yyyy","yyyy-MM-dd") will get 2024-01-08 .

@saig0 Check this out, it's a implementation of java test: format data time, timestamp in different formats, I'm not sure how to implementat in scala.