LucidDbAppLib CALENDAR QUARTER

From Eigenpedia

Contents 1 Syntax 2 Purpose 3 Parameters 4 Output 5 Example 6 Source Code

Syntax

APPLIB.CALENDAR_QUARTER ( [ date_expression | timestamp_expression ] )

Purpose

Returns the calendar year quarter of the given date or timestamp.

Parameters

• date_expression: date from which to derive the calendar quarter [DATE]
• timestamp_expression : timestamp from which to derive the calendar quarter [TIMESTAMP]

Output

• [VARCHAR(128)] calendar year quarter string in the format Q#CY##. Returns null if any inputs are null.

Example

VALUES( APPLIB.CALENDAR_QUARTER(DATE'1998-02-20'), APPLIB.CALENDAR_QUARTER(TIMESTAMP'2002-12-12 01:56:00') )

returns

CALENDAR_QUARTER(DATE'1998-02-20')	CALENDAR_QUARTER(TIMESTAMP'2002-12-12 01:56:00')
Q1CY98	Q4CY02

Source Code

http://p4web.eigenbase.org/open/dev/luciddb/src/com/lucidera/luciddb/applib/datetime/CalendarQuarterUdf.java

---

Return to LucidDbAppLib page