Differences between Actuate SQL functions and database functions
Your database’s implementation of certain SQL functions may differ slightly from the Actuate SQL implementation of the same functions. For example, the Actuate SQL function DATEPART (weekday) is used to find the weekday of a date. The Actuate SQL function DATEPART(weekday) returns 0 for Sunday. On your database, a similar function WEEKDAY may return 1 for Sunday. The JDBC driver may hide this from the Integration service, but if it does not, a query would return incorrect values for the weekday of each date. Thus, you need to edit mappings.xml to define an appropriate substitute for the Actuate SQL function DATEPART.

Additional Links:

Copyright Actuate Corporation 2012