![]() SELECT floor((TIMESTAMP ' 10:00' - TIMESTAMP '') / interval '7') SELECT cast((TIMESTAMP ' 10:00' - TIMESTAMP '') day as integer) / 7 SELECT (TIMESTAMP ' 10:00' - TIMESTAMP '') day ![]() SELECT (TIMESTAMP ' 10:00' - TIMESTAMP '') / 7 SELECT (TIMESTAMP ' 10:00' - TIMESTAMP '') (1 row) Examples: TIMESTAMP Computation Statement => SELECT TIMESTAMP WITH TIME ZONE 'March 1, 44 12:00 BC CET' "Caesar's Time of Death EST" => SELECT TIMESTAMP WITH TIME ZONE 'March 1, 44 12:00 CET BC ' "Caesar's Time of Death EST" The following list represents typical date/time input variations: The input string can include a time zone, specified as a literal such as America/Chicago, or as a UTC offset. The date/time input string concatenates a date and a time. See Date/Time Data Types for more detail. In the following table, values are rounded. If the input string omits a time zone, Vertica uses the UTC offset of the time zone that is configured for your system.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |