Results of 1 - 10 of about 22 for width (0.006 sec.)
- Timestamp with Time Zone Functions – DuckDB 12609
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...format) Converts string to TIMESTAMP WITH TIME ZONE according to the format string if %Z is specified. time_bucket(bucket_width, timestamptz[, offset]) Truncate timestamptz to a grid of width bucket_width . The grid is anchored at 2000-01-01 00:00:00...+00:00[ + offset] when bucket_width is a number of months or coarser units, else 2000-01-03 00:00:00+00:00[ + offset] . Note that 2000-01-03 is a Monday. time..._bucket(bucket_width, timestamptz[, origin]) Truncate timestamptz to a grid of width bucket_width . The grid is anchored at the origin timestam... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamptz.html
- Date Functions – DuckDB 12087
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...name of the month. strftime(date, format) Converts a date to a string according to the format string . time_bucket(bucket_width, date[, offset]) Truncate date to a grid of width bucket_width . The grid is anchored at 2000-01-01[ + offset] when bucket..._width is a number of months or coarser units, else 2000-01-03[ + offset] . Note that 2000-01-03 is a Monday. time_bucket(bucket_...width, date[, origin]) Truncate timestamptz to a grid of width bucket_width . The grid is anchored at the origin timestamp, which defaults to 2000-01-01 when bucket_width is a number of... - https://man.mtool.work/duckdb/1.3/sql/functions/date.html
- Timestamp Functions – DuckDB 11161
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ording to the format string . Throws an error on failure. To return NULL on failure, use try_strptime . time_bucket(bucket_width, timestamp[, offset]) Truncate timestamp to a grid of width bucket_width . The grid is anchored at 2000-01-01 00:00:00[ +...offset] when bucket_width is a number of months or coarser units, else 2000-01-03 00:00:00[ + offset] . Note that 2000-01-03 is a Monday. time_bucke...t(bucket_width, timestamp[, origin]) Truncate timestamp to a grid of width bucket_width . The grid is anchored at the origin timestamp, w... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamp.html
- Numeric Types – DuckDB 10908
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...tra bytes). Both negative and positive values are supported by the VARINT type. Fixed-Point Decimals The data type DECIMAL(WIDTH, SCALE) (also available under the alias NUMERIC(WIDTH, SCALE) ) represents an exact fixed-point decimal value. When creati...ng a value of type DECIMAL , the WIDTH and SCALE can be specified to define which size of decimal values can be held in the field. The WIDTH field determines how...or example, the type DECIMAL(3, 2) can fit the value 1.23 , but cannot fit the value 12.3 or the value 1.234 . The default WIDTH and SCALE is DECIMAL(18, 3) , if none are specified. Addition, subtraction, and multiplication of two fixed-point decimals... - https://man.mtool.work/duckdb/1.3/sql/data_types/numeric.html
- Types – DuckDB 9460
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...nt duckdb_double_to_hugeint ( double val ); Decimal Helpers duckdb_decimal duckdb_double_to_decimal ( double val , uint8_t width , uint8_t scale ); double duckdb_decimal_to_double ( duckdb_decimal val ); Logical Type Interface duckdb_logical_type duck...te_enum_type ( const char ** member_names , idx_t member_count ); duckdb_logical_type duckdb_create_decimal_type ( uint8_t width , uint8_t scale ); duckdb_type duckdb_get_type_id ( duckdb_logical_type type ); uint8_t duckdb_decimal_width ( duckdb_logi...al Converts a double value to a duckdb_decimal object. If the conversion fails because the double value is too big, or the width/scale are invalid the result will be 0. Syntax duckdb_decimal duckdb_double_to_decimal ( double val , uint8_t width , uint... - https://man.mtool.work/duckdb/1.3/clients/c/types.html
- Functions – DuckDB 8871
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ion_name ; function_name function_type return_type parameters parameter_types description bar scalar VARCHAR [x, min, max, width] [DOUBLE, DOUBLE, DOUBLE, DOUBLE] Draws a band whose width is proportional to (x - min) and equal to width characters when...x = max. width defaults to 80 base64 scalar VARCHAR [blob] [BLOB] Convert a blob to a base64 encoded string bin scalar VARCHAR [value] [V...vailable in the duckdb_functions() function. Pages in This Section 関連キーワード goose scalar functions type replace duck width bitstring Functions chaining call following return Parser duckdb parameter description length DuckDB syntax rewritten exam... - https://man.mtool.work/duckdb/1.3/sql/functions/overview.html
- Dot Commands – DuckDB 8282
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...or off . FILE can be stderr / stdout .maxrows COUNT Sets the maximum number of rows for display. Only for duckbox mode .maxwidth COUNT Sets the maximum width in characters. 0 defaults to terminal width. Only for duckbox mode .mode MODE TABLE Set outpu...timer on/off Turn SQL timer on or off . SQL statements separated by ; but not separated via newline are measured together .width NUM1 NUM2 ... Set minimum column widths for columnar output Using the .help Command The .help text may be filtered by pass...argument. .help m .maxrows COUNT Sets the maximum number of rows for display ( default : 40 ). Only for duckbox mode . .maxwidth COUNT Sets the maximum width in characters . 0 defaults to terminal width . Only for duckbox mode . .mode MODE ? TABLE ? S... - https://man.mtool.work/duckdb/1.3/clients/cli/dot_commands.html
- R Client – DuckDB 8097
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
..., "iris_table" , iris ) res <- dbGetQuery ( con , "SELECT * FROM iris_table LIMIT 1" ) print ( res ) # Sepal.Length Sepal.Width Petal.Length Petal.Width Species # 1 5.1 3.5 1.4 0.2 setosa It is also possible to “register” a R data frame as a virtual...on , "iris_view" , iris ) res <- dbGetQuery ( con , "SELECT * FROM iris_view LIMIT 1" ) print ( res ) # Sepal.Length Sepal.Width Petal.Length Petal.Width Species # 1 5.1 3.5 1.4 0.2 setosa DuckDB keeps a reference to the R data frame after registratio... - https://man.mtool.work/duckdb/1.3/clients/r.html
- Text Functions – DuckDB 8097
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...string) Returns an integer that represents the Unicode code point of the first character of the string . bar(x, min, max[, width]) Draws a band whose width is proportional to ( x - min ) and equal to width characters when x = max . width defaults to 8...t represents the Unicode code point of the first character of the string . Example ascii('Ω') Result 937 bar(x, min, max[, width]) Description Draws a band whose width is proportional to ( x - min ) and equal to width characters when x = max . width d... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Complete API – DuckDB 8030
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...t duckdb_double_to_uhugeint ( double val ); Decimal Helpers duckdb_decimal duckdb_double_to_decimal ( double val , uint8_t width , uint8_t scale ); double duckdb_decimal_to_double ( duckdb_decimal val ); Prepared Statements duckdb_state duckdb_prepare...te_enum_type ( const char ** member_names , idx_t member_count ); duckdb_logical_type duckdb_create_decimal_type ( uint8_t width , uint8_t scale ); duckdb_type duckdb_get_type_id ( duckdb_logical_type type ); uint8_t duckdb_decimal_width ( duckdb_logi...al Converts a double value to a duckdb_decimal object. If the conversion fails because the double value is too big, or the width/scale are invalid the result will be 0. Syntax duckdb_decimal duckdb_double_to_decimal ( double val , uint8_t width , uint... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
DuckDB 1.3 Documentation / man.mtool.work