monthEnd

swordfish.function.monthEnd()

Return the last day of the month that X belongs to.

If parameter offset is specified, the result is updated every n months. The parameters offset and n must be specified together, and offset takes effect only when n > 1.

Parameters:

• X (Constant) – A scalar/vector of data type DATE, DATEHOUR, DATETIME, TIMESTAMP or NANOTIMESTAMP.

• offset (Constant) – A scalar of the same data type as X. It must be no greater than the minimum value of X. The default value is the minimum value of X.

• n (Constant) – A positive integer. The default value is 1.