Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

D toc

Excerpt

D s product
rtrue
 supports a variety of date-time Datetime formats, each of which has additional variations to it.

Date Range

Supported Date Ranges:  

  • Earliest: January 1, 1400
  • Latest: December 31, 2599


You can use dates in the Gregorian calendar system only. Dates in the Julian calendar are not supported.

Formatting Tokens

You can use the following format strings tokens to change the format of a column of dates:

...

  • 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. If you want to work with local times, you can truncate the time zone or use other Datetime functions. See UNIXTIME Function.

...