In this section: |
The QUARTER and WEEKDAY SQL functions are supported.
How to: |
Given a date or date-time value, QUARTER returns an integer (from 1 to 4) that represents the quarter within which that date falls.
QUARTER(arg)
where:
Date or date-time
Is the input date or date-time value.
QUARTER returns the quarter of the year for each date of birth:
QUARTER(DATE_OF_BIRTH)
For 1993/03/27, the result is 1.
How to: |
Given a date or date-time value, WEEKDAY returns an integer from 1 (Monday) to 7 (Sunday) representing the day of the week for that date.
WEEKDAY(arg)
where:
Date or date-time
Is the input date or date-time value.
WEEKDAY returns the day of the week for each birth date, where 1 represents Monday and 7 represents Sunday:
WEEKDAY(DATE_OF_BIRTH)
For 1993/03/27, the result is 6 (Saturday).
WebFOCUS |