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.
q = foreach q generate CloseDate as 'Close Date';
Project the year, month, day, and epoch date for a record.
q = foreach q generate year('CloseDate') as 'Year', month('CloseDate') as 'Month', day('CloseDate') as 'Day', epochSecond('CloseDate') as 'Seconds Epoch';