Results of 1 - 7 of about 7 for exclusive (0.002 sec.)
- Time Functions 13232
- This section describes functions and operators for examining and manipulating TIME values . Time Operators The table below shows the available mathematical operators for TIME types. Operator Description Example Result + addition of an INTER
...f(part, starttime, endtime) The number of part boundaries between starttime and endtime , inclusive of the larger time and exclusive of the smaller time. date_part(part, time) Get subfield (equivalent to extract ). date_sub(part, starttime, endtime) The s...e, endtime) | Description | The number of part boundaries between starttime and endtime , inclusive of the larger time and exclusive of the smaller time. | | Example | date_diff('hour', TIME '01:02:03', TIME '06:01:03') | | Result | 5 | | Alias | datediff... - https://man.mtool.work/duckdb/2.0/sql/functions/time.html
- Date Functions 9905
- This section describes functions and operators for examining and manipulating DATE values. Date Operators The table below shows the available mathematical operators for DATE types. Operator Description Example Result + addition of days (int
...f(part, startdate, enddate) The number of part boundaries between startdate and enddate , inclusive of the larger date and exclusive of the smaller date. date_part(part, date) Get subfield (equivalent to extract ). date_sub(part, startdate, enddate) The s...e, enddate) | Description | The number of part boundaries between startdate and enddate , inclusive of the larger date and exclusive of the smaller date. | | Example | date_diff('month', DATE '1992-09-15', DATE '1992-11-14') | | Result | 2 | | Alias | dat... - https://man.mtool.work/duckdb/2.0/sql/functions/date.html
- Timestamp Functions 8469
- This section describes functions and operators for examining and manipulating TIMESTAMP values . See also the related TIMESTAMPTZ functions . Timestamp Operators The table below shows the available mathematical operators for TIMESTAMP types
...ndtimestamp) The number of part boundaries between starttimestamp and endtimestamp , inclusive of the larger timestamp and exclusive of the smaller timestamp. date_part([part, ...], timestamp) Get the listed subfields as a struct . The list must be consta...ion | The signed number of part boundaries between starttimestamp and endtimestamp , inclusive of the larger timestamp and exclusive of the smaller timestamp. | | Example | date_diff('hour', TIMESTAMP '1992-09-30 23:59:59', TIMESTAMP '1992-10-01 01:58:00'... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamp.html
- Iceberg Extension 7979
- The iceberg extension implements support for the Apache Iceberg open table format . There are two ways to work with Iceberg in DuckDB: Individual tables are read directly from storage, by pointing at a table's metadata. This requires no cat
...el To read a historical snapshot of a table, pass either snapshot_from_id or snapshot_from_timestamp (the two are mutually exclusive). Use iceberg_snapshots to list the available snapshots: -- Read a specific snapshot by id SELECT count(*) FROM iceberg_sc... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/overview.html
- List Functions 7979
- Function Description list[index] Extracts a single list element using a (1-based) index . list[begin[:end][:step]] Extracts a sublist using slice conventions . Negative values are accepted. list1 && list2 Alias for list_has_any . list1 <->
...smallest list length. range(start[, stop][, step]) Creates a list of values between start and stop - the stop parameter is exclusive. reduce(list, lambda(x,y)[, initial_value]) Alias for list_reduce . repeat(list, count) Repeats the list count number of t...zip | range(start[, stop][, step]) | Description | Creates a list of values between start and stop - the stop parameter is exclusive. | | Example | range(2, 5, 3) | | Result | [2] | repeat(list, count) | Description | Repeats the list count number of time...eates a list of values in the range between start and stop . The start parameter is inclusive, while the stop parameter is exclusive. The default value of start is 0 and the default value of step is 1. Based on the number of arguments, the following varia... - https://man.mtool.work/duckdb/2.0/sql/functions/list.html
- Timestamp with Time Zone Functions 7979
- 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
...mestamptz) The number of part boundaries between starttimestamptz and endtimestamptz inclusive of the larger timestamp and exclusive of the smaller timestamp. date_part([part, ...], timestamp) Get the listed subfields as a struct . The list must be consta...| The signed number of part boundaries between starttimestamptz and endtimestamptz , inclusive of the larger timestamp and exclusive of the smaller timestamp. | | Example | date_diff('hour', TIMESTAMPTZ '1992-09-30 23:59:59', TIMESTAMPTZ '1992-10-01 01:58... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamptz.html
- Utility Functions 7979
- Scalar Utility Functions The functions below are difficult to categorize into specific function types and are broadly useful. Name Description alias(column) Return the name of the column. can_cast_implicitly(source_value, target_value) Whet
...path may contain glob pattern matching syntax . range(start, stop, step) Returns a table of values between start and stop (exclusive), incrementing by step . repeat(value, count) Returns a table with count rows, each containing value . repeat_row(varargs,...top, step) | Description | Returns a table of values between start and stop , incrementing by step . The stop parameter is exclusive, and the start and step arguments are optional. See the list variant for the available argument combinations. | | Example... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work