monthBegin

swordfish.function.monthBegin()

Return the first 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.

参数:

• 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.