Use Time Zone-Enabled Dates in SAQL Projections

You can project an exact date such as 2017-3-31 23:59:59 or part of a date such as year, month, or day.

Project the entire CloseDate field to see the CloseDate field for a record. CloseDate can be a DateTime or DateOnly type.

1q = foreach q generate CloseDate as 'Close Date';

Project the year, month, day, and epoch date for a record.

1q = foreach q generate year('CloseDate') as 'Year', month('CloseDate') as 'Month', day('CloseDate') as 'Day', epochSecond('CloseDate') as 'Seconds Epoch';