About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Last updated: Feb 11, 2025
Note that conversion functions (and any other functions that require a specific type of input, such as a date or time value) depend on the current formats specified in the flow properties.
For example, if you have a field named DATE that's stored as a string with values Jan 2021, Feb 2021, and so on, you could convert it to date storage as follows:
to_date(DATE)
For this conversion to work, select the matching date format MON YYYY as the default date format for the flow.
Dates stored as numbers. Note that
in the previous example is the name of a field, while DATE
is a CLEM function. If you have dates stored as numbers, you can convert them using the
to_date
function, where the number is interpreted as a number of seconds
since the base date (or epoch).datetime_date
datetime_date(DATE)
By converting a date to a number of seconds (and back), you can perform calculations such as computing the current date plus or minus a fixed number of days. For example:
datetime_date((date_in_days(DATE)-7)*60*60*24)
Was the topic helpful?
0/1000