These functions provide tools for interpreting date values. Many of these functions process and return the information as a date which can be compared to other date and time values. Many of these functions require values in date or time zone format as parameters. The parameters are generated by nesting the functions ecm:toDate and ecm:timeZone.

Modifications to the extracted values are made for the purposes of the query only. The actual data stored in the target source is not changed in any way.


Function

Description

​ecx:formatDate​

Formats a date according to the specified pattern.

​ecx:fmtDateInTimeZone​

Interprets a given date in the specified source time zone. It then sets the specified target time zone on the date but retains the date and time fields as they were on the original date.

​ecx:formatTimestamp​

Returns a timestamp in the desired string format.

​ecx:getDate​

Returns the current date in the format 'yyyyMMdd' with the specified time zone.

​ecx:getTime​

Returns the current time in the format 'HHmmss" with the specified time zone.

​ecx:getDateTime​

Returns the current date and time in the format 'yyyyMMddHHmmss' with specified time zone.

​ecm:addInterval​

Adds (or subtracts) an interval of time to a specified date.

​ecm:day​

Returns the day component of the referenced date.

​ecm:month​

Returns the month component of the referenced date.

​ecm:year​

Returns the year component of the referenced date.

​ecm:timeZone​

Converts the specified time zone ID to a (Java utility class) time zone.

​ecm:trunc​

Returns a new date where the specified time or date component is reset to a default value (truncated).