Results of 1 - 1 of about 1 for starttimestamptz (0.001 sec.)
- Timestamp with Time Zone Functions 9414
- This section describes functions and operators for examining and manipulating TIMESTAMP WITH TIME ZONE (or TIMESTAMPTZ ) values . See also the related TIMESTAMP functions . Time zone support is provided by the built-in ICU extension . In th
...resulting in the time difference between the two timestamps. age(timestamptz) Subtract from current_date. date_diff(part, starttimestamptz, endtimestamptz) The number of part boundaries between starttimestamptz and endtimestamptz inclusive of the larger timesta...as a struct . The list must be constant. date_part(part, timestamp) Get subfield (equivalent to extract ). date_sub(part, starttimestamptz, endtimestamptz) The signed length of the interval between starttimestamptz and endtimestamptz , truncated to whole multip...rrent_date. | | Example | age(TIMESTAMP '1992-09-20') | | Result | 29 years 1 month 27 days 12:39:00.844 | date_diff(part, starttimestamptz, endtimestamptz) | Description | The signed number of part boundaries between starttimestamptz and endtimestamptz , inclus... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamptz.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work