...

Date Range

Supported Date Ranges:  

• Earliest: January 1, 1400
  

  Info
  NOTE: Two-digit values for the year that are older than 80 years from the current year are forward-ported into the future in D s product . This behavior may be different from source and target systems. See "Two-digit year values" below.

• Latest: December 31, 2599

...

...

• Support for timezone offset from UTC indicated by +hh:mm, +hhmm, or +hh. For example, the date '2013-11-18 11:55-04:00' is recognized as a DateTime value.

• Datetime part functions (for example, Hour) truncate time zones and return local time.
• If you have a column with multiple time zones, you can convert the column to Unixtime so you can perform Date/Time operations with a standardized time zone using the UNIXTIME function. If you want to work with local times, you can truncate the time zone or use other Datetime functions. 

Two-digit year values

Depending on the system, a two-digit value for year in a Datetime value is subject to different interpretations.

...

In 

Other systems use different limits for backward versus forward porting of year values:

• In BigQuery, if no century value is provided, then the year value has a century value applied to it based on a fixed range. See https://cloud.google.com/bigquery/docs/reference/standard-sql/format-elements#:~:text=The%20year%20without%20century%20as%20a%20decimal%20number%20(00%2D99).
• Snowflake permits customization of two-digit year values at the Account, Session, or Object level. See https://docs.snowflake.com/en/sql-reference/parameters.html#two-digit-century-start.

As a result, it can be a challenge to manage these system-dependent two-digit years in a consistent manner. 

If the above is not possible, you can create replacement steps in your recipe to convert two-digit years to four-digit values. In the following example, 00-39 is interpreted as a 19XX year, while 40-99 is interpreted as a 20XX year: 

and

Supported Datetime Formats

For more information on the available formats and examples of each one, see Datetime Formats (PDF).For more information on supported date formatting strings, see DATEFORMAT Function

You can use the DATEFORMAT function to modify the formatting of your Datetime values.

Supported Time Zones

For more information, see Supported Time Zone Values.Time zones values (e.g. UTC-08:00) are supported. 

Job Execution

Datetime data typing involves the basic type definition, plus any supported formatting options. Depending on where the job is executed, there may be variation in how the Datetime data type is interpreted. 

...

If your Datetime data does not contain time zone information, by default:

• Spark uses the time zone of the 

  D s item
  item node

   for Datetime values.
  
  

  Tip
  Tip: This use of time zone applies to any Spark-based running environment, such as EMR.

• D s photon

   uses the UTC time zone for Datetime values.

...

• Set the time zone for the 

  D s item
  item node

   to be UTC. You must also set the time zone for your Spark running environment to UTC.

• Apply the following Spark property overridesexecution properties from the Run Job page:
  
  

  Code Block
  "spark": "props": { ... "spark.driver.extraJavaOptions" : "-Duser.timezone=\"UTC\"", "spark.executor.extraJavaOptions" : "-Duser.timezone=\"UTC\"" } ... }

Datetime Schema via API

When Datetime data is returned via API calls, the schema for this information is returned as a three-element array. The additional elements to the specific are required to account for formatting options of for Datetime values.

...

Example:

"end_date": [
            "Datetime",
            "mm-dd-yy",
            "mm*dd*yyyy"
        ]