SQL QUARTER scalar function in DB2 for i SQL

SQL QUARTER scalar function in DB2 for i SQL

QUARTER

he QUARTER function returns the quarter of the year in which the date resides i.e than integer between 1 and 4.

For example, any dates in January, February, or March return the integer 1.

Any dates in April, May, or June return the integer 2.

Any dates in July, August, or september return the integer 3.

Any dates in October, November, or December return the integer 4.

Syntax of QUARTER

QUARTER(expression)

The argument should be an expression that returns either date, timestamp, character string, graphic string, or any numeric data type. The return value is the large integer. Also, the result can be NULL if the argument value is null.

Example#1:

If the argument is a string.

SELECT  QUARTER('2024-03-16') FROM sysibm.sysdummy1

      QUARTER
            1

Or

SELECT QUARTER('2024-04-16-15.10.40.456465') FROM sysibm.sysdummy1

      QUARTER
            2

Example#2:

The result can be null if the argument is null.

Create a table having date field and that allows null value to be inserted.

CREATE TABLE QTEMP/DT (DATE1 DATE )

INSERT INTO QTEMP/DT VALUES(null)

Output

DATE1
-    

select QUARTER(date1) from qtemp/dt

QUARTER ( DATE1 ) 
               -  

Returns NULL value as date1 field has NULL value in table qtemp/dt.

Example#3:

If the argument is a timestamp.

SELECT  QUARTER(current timestamp) FROM sysibm.sysdummy1

Or

SELECT  QUARTER(current_timestamp) FROM sysibm.sysdummy1

      QUARTER
            1

Example#4:

Argument value is the character string '2024076', which represents a date in the format yyyynnn, where yyyy is the year, and nnn is the day of the year.

SELECT   QUARTER('2024076'), QUARTER('2024176'), QUARTER('2024220') 
, QUARTER('2024276')                                                
 FROM sysibm.sysdummy1                                              

      QUARTER         QUARTER         QUARTER         QUARTER
            1               2               3               4