Difference between revisions of "QUARTER()"

From Recital Documentation Wiki
Jump to: navigation, search
 
(Products)
 
(One intermediate revision by one user not shown)
Line 1: Line 1:
=QUARTER()=
 
 
 
==Class==
 
Date and Time Data
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to return year quarter for the specified date or datetime
 
Function to return year quarter for the specified date or datetime
Line 34: Line 27:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital, Recital Server
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]

Latest revision as of 15:05, 7 December 2009

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

Recital, Recital Server