Project a Date Field

To project a date field of type DateTime, use the EXTRACT() function on the date field in the SELECT statement.

1SELECT CloseDate
2FROM "OpportunityFiscalEMTimezoned"
3LIMIT 1;

This example projects only the year from the DateTime field.

1SELECT EXTRACT(Year FROM CloseDate) As CloseDate_Year
2FROM "OpportunityFiscalEMTimezoned"
3LIMIT 1;

j

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

First and Last Day in the Week, Month, Quarter or Year Functions

Aggregate Functions

Math Functions

String Functions and Operators

Release Notes

Previous Versions