Date/Time

Vertica supports the full set of SQL date and time types. In most cases, a combination of DATE, TIME, TIMESTAMP WITHOUT TIME ZONE, and TIMESTAMP WITH TIME ZONE should provide a complete range of date/time functionality required by any application. However, in compliance with the SQL standard, Vertica also supports the TIME WITH TIMEZONE data type.

Notes

• Vertica uses Julian dates for all date/time calculations. They can correctly predict and calculate any date more recent than 4713 BC to far into the future, based on the assumption that the length of the year is 365.2425 days.
• All date/time types are stored in eight bits.
• A date/time value of NULL appears first (smallest) in ascending order.
• All the date/time data types accept the special literal value NOW to specify the current date and time. For example:

  SELECT TIMESTAMP 'NOW';