Project a Date Field
To project a date field of type DateTime, use the EXTRACT() function on the date field in the SELECT statement.
| CloseDate |
|---|
| 2014-12-30 16:00:00 |
This example projects only the year from the DateTime field.
| CloseDate_Year |
|---|
| 2014 |