Difference between revisions of "QUARTER()"
From Lianjapedia
m (Text replace - "Recital" to "Lianja") |
Helen.george (Talk | contribs) |
||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to return year quarter for the specified date or datetime | Function to return year quarter for the specified date or datetime | ||
| − | |||
==Syntax== | ==Syntax== | ||
QUARTER(<expD> | <expT>[, <expN>]) | QUARTER(<expD> | <expT>[, <expN>]) | ||
| − | |||
==See Also== | ==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]] | [[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== | ==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). | 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== | ==Example== | ||
| Line 24: | Line 20: | ||
4 | 4 | ||
</code> | </code> | ||
| − | |||
==Products== | ==Products== | ||
Revision as of 10:19, 12 December 2012
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
