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)
Copy to clipboardCopied to clipboard
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
DATE in the previous example is the name of a field, while to_date
is a CLEM function. If you have dates stored as numbers, you can convert them using the
datetime_date function, where the number is interpreted as a number of seconds
since the base date (or epoch).
datetime_date(DATE)
Copy to clipboardCopied to clipboard
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:
About cookies on this siteOur 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 cookie preferences 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.