---
schema_version: "1"
id: 57e98ae74204d86305606769afb9c3d4a6e92dda2a18a2e3c45334200802efa2
title: Use Time Zone-Enabled Dates in SAQL Projections
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_saql/guides/concept/bi-saql-functions-timezone-use.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-saql-functions-timezone-use.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: e27a8c0edfa69989cc9fa9149cbb2fc43d846633fc64536f3ddefcf526356d90
products:
  - Analytics SAQL Developer Guide
  - analytics
---

# 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.

```nolang

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

```

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

```nolang

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

```