---
schema_version: "1"
id: 8f9d430ad2738dc315b83516b5ad36dba2523bcea97a2995fe9459acf5e58031
title: Convert Dates to and from Strings
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-strings.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-saql-functions-timezone-strings.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 7eaacc7aec7920faf686509e815e86b2e1e59bde43b53833d292958e216cb183
products:
  - Analytics SAQL Developer Guide
  - analytics
---

# Convert Dates to and from Strings

You can convert dates to strings.

- **[date_to_string(DateTime | DateOnly, format)](https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-saql-functions-timezone-date2string.md)**


    Converts a date to a string.

- **[toDateTime(epoch)](https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-saql-functions-timezone-datetime-epoch.md)**


    Converts an epoch day to a `DateTime` type.

- **[toDateTime(string, format)](https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-saql-functions-timezone-datetime-string.md)**


    Converts a date in string format to a `DateTime` type. _“format”_ specifies the date format and can be any valid date format.

- **[toDateOnly(epoch)](https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-saql-functions-timezone-dateonly-epoch.md)**


    Converts an epoch to a `DateOnly` type.

- **[toDateOnly(string, format)](https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-saql-functions-timezone-dateonly-string.md)**


    Converts a date in string format to a `DateOnly` type. _format_ specifies the date format and can be any valid date format.