Day in Week, Month, Quarter or Year Functions

Use the following functions to find the position of a day within a week, month, quarter, or year.

Date position functions take this syntax.

1SELECT EXTRACT (FUNCTIONNAME FROM DATE) AS DATEALIAS
2FROM DATASET;

  • Day of Week

    Returns an integer that represents the day of the week for a specific date.

  • Day of Month

    Returns an integer that represents the day of the month for a specific date.

  • Day of Quarter

    Returns an integer that represents the day of the quarter for a specific date. The first quarter of the year begins on January 1.

  • Day of Year

    Returns an integer that represents the day of the year for a specific date.

Introducing SQL for CRM Analytics
Quick Start: Run Your First Query
SQL vs SAQL
SQL Statements
Date Functions
Access Parts of a Date
Project a Date Field
Filter By Date Parts or Date Field
Group By Date Part
Order By Date Part
Project a Custom Fiscal Date Part
Day in Week, Month, Quarter or Year Functions
Day of Week
Day of Month
Day of Quarter
Day of Year
First and Last Day in the Week, Month, Quarter or Year Functions
Aggregate Functions
Math Functions
String Functions and Operators
Release Notes
Previous Versions