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