Previous Topic Next topic Print topic

Micro Focus Enterprise Developer 3.0 for Visual Studio 2013 > Programming > Mainframe Programming > SQL Option for DB2 > Reference > SQL Reference > Functions Overview > Date And Time Functions (XDB Mode) > QUARTERBEG

QUARTERBEG

ANSI DB2 SQL/DS XDB
      X

This function is used to obtain the date of the first day of the quarter in which the date resides. The format appears below:

QUARTERBEG(date)

For example:

QUARTERBEG(2/14/1991) = 1/1/1991
QUARTERBEG(5/14/1991) = 4/1/1991
Parent topic: Date And Time Functions (XDB Mode)
Previous Topic Next topic Print topic