IBM Support

FIRST_DAY built-in scalar function

News


Abstract

FIRST_DAY is a new built-in scalar function that can be used to derive the first day of the month in date or timestamp format.

Content


 

first day

See the SQL Reference for details: FIRST_DAY

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CHeAAM","label":"IBM i Db2"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.4.0;7.5.0;and future releases"}]

Document Information

Modified date:
11 October 2022

UID

ibm16828075