Results of 1 - 8 of about 8 for inclusive (0.004 sec.)
- Time Functions 12652
- 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
...lue without a time zone. date_diff(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_su...ssary) | date_diff(part, starttime, 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') |... - https://man.mtool.work/duckdb/2.0/sql/functions/time.html
- Date Functions 10121
- 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
...return a DATETIME value. date_diff(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_su...:00:00 | date_diff(part, startdate, 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... - https://man.mtool.work/duckdb/2.0/sql/functions/date.html
- List Functions 9760
- 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 <->
...one level. generate_series(start[, stop][, step]) Creates a list of values between start and stop - the stop parameter is inclusive. grade_up(list[, col1][, col2]) Alias for list_grade_up . len(list) Alias for length . length(list) Returns the length of...rate_series(start[, stop][, step]) | Description | Creates a list of values between start and stop - the stop parameter is inclusive. | | Example | generate_series(2, 5, 3) | | Result | [2, 5] | length(list) | Description | Returns the length of the list...nted below. range The range function creates 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 n... - https://man.mtool.work/duckdb/2.0/sql/functions/list.html
- Timestamp Functions 9037
- 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
...on). date_diff(part, starttimestamp, endtimestamp) 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...arttimestamp, endtimestamp) | Description | 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:5... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamp.html
- Timestamp with Time Zone Functions 8675
- 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
...ate_diff(part, starttimestamptz, endtimestamptz) 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...tamptz, endtimestamptz) | Description | 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... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamptz.html
- Utility Functions 8675
- 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
...le in a FROM clause. Name Description generate_series(start, stop, step) Returns a table of values between start and stop (inclusive), incrementing by step . glob(search_path) Return filenames found at the location indicated by the search_path in a single...top, step) | Description | Returns a table of values between start and stop , incrementing by step . The stop parameter is inclusive, and the stop 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
- Spatial Functions 6868
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...lon/lat point at a given level. Note that the parameter order is longitude , latitude . level has to be between 1 and 23, inclusive. The input coordinates will be clamped to the lon/lat bounds of the earth (longitude between -180 and 180, latitude betwee... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Python Client API 6506
- Connection class duckdb. Appender Bases: object append_row ( self , * args ) → None Buffer one row, one value per column, each converted as an executemany parameter would be append_rows ( self , rows : object ) → None Buffer each row of an
..., high : object = <object object> , * , lower : object = <object object> , upper : object = <object object> ) → Expression Inclusive range; lower and upper are the earlier API's names for the same two bounds. bit_and ( * args : ValueOrExpr ) → Expression... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work