QUARTER()

From Lianjapedia
Jump to: navigation, search

Purpose

Function to return year quarter for the specified date or datetime

Syntax

QUARTER(<expD> | <expT>[, <expN>])

See Also

CDOW(), CMONTH(), CTOD(), DATE(), DATETIME(), DAY(), DAYS(), DMY(), DOW(), DTOC(), DTOM(), DTOS(), DTOV(), EPOCH(), GOMONTH(), MDY(), MONTH(), MTOD(), STOD(), VTOD(), WEEK(), YEAR(), SET CENTURY, SET DATE, SET EPOCH, SET HOURS, SET MARK

Description

The QUARTER() function returns the year quarter for the specified date expression <expD> or datetime expression <expT>. The optional <expN> is used to specify the number of an alternative starting month for the year; the default is 1 (January).

Example

? quarter({01/22/2004})
         1
? quarter({^20040822 12:34:29 PM})
         3
? quarter({01/22/2004},2)
         4

Products

Lianja, Lianja Server