Results of 1 - 10 of about 16 for converts (0.007 sec.)
- Blob Functions – DuckDB 13325
- 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 blobs. Any NULL input results in NULL . See also concat(arg1, arg2, ...) and list_concat(list1, list2) . base64(blob) Converts a blob to a base64 encoded string. concat(value, ...) Concatenates multiple strings, lists, or blobs. NULL inputs are skip...ped. See also operator || . decode(blob) Converts blob to VARCHAR . Fails if blob is not valid UTF-8. encode(string) Converts the string to BLOB . Converts UTF-8 characters...into literal encoding. from_base64(string) Converts a base64 encoded string to a character string ( BLOB ). from_binary(value) Converts a value from binary representation to... - https://man.mtool.work/duckdb/1.3/sql/functions/blob.html
- Text Functions – DuckDB 12026
- 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
...whose width is proportional to ( x - min ) and equal to width characters when x = max . width defaults to 80. base64(blob) Converts a blob to a base64 encoded string. bin(string) Converts the string to binary representation. bit_length(string) Number of...g ends with search_string . format(format, ...) Formats a string using the fmt syntax . formatReadableDecimalSize(integer) Converts integer to a human-readable representation using units based on powers of 10 (KB, MB, GB, etc.). formatReadableSize(intege...r) Converts integer to a human-readable representation using units based on powers of 2 (KiB, MiB, GiB, etc.). format_bytes(integer) C... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Timestamp Functions – DuckDB 10327
- 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
...Alias of date_trunc . Truncate to specified precision . dayname(timestamp) The (English) name of the weekday. epoch_ms(ms) Converts milliseconds since the epoch to a timestamp. epoch_ms(timestamp) Returns the total number of milliseconds since the epoch...._timestamp(bigint, bigint, bigint, bigint, bigint, double) The timestamp for the given parts. make_timestamp(microseconds) Converts microseconds since the epoch to a timestamp. make_timestamp_ns(nanoseconds) Converts nanoseconds since the epoch to a time...stamp. monthname(timestamp) The (English) name of the month. strftime(timestamp, format) Converts timestamp to string according to the format string . strptime(text, format-list) Converts the string text to timestamp app... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamp.html
- Timestamp with Time Zone Functions – DuckDB 9686
- 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
...The earlier of two timestamps. now() Current date and time (start of current transaction). timetz_byte_comparable(timetz) Converts a TIME WITH TIME ZONE to a UBIGINT sort key. to_timestamp(double) Converts seconds since the epoch to a timestamp with tim...(start of current transaction). Example now() Result 2022-10-08 12:44:46.122-07 timetz_byte_comparable(timetz) Description Converts a TIME WITH TIME ZONE to a UBIGINT sort key. Example timetz_byte_comparable('18:18:16.21-07:00'::TIMETZ) Result 2494691656...335442799 to_timestamp(double) Description Converts seconds since the epoch to a timestamp with time zone. Example to_timestamp(1284352323.5) Result 2010-09-13 04:32:03.5+00... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamptz.html
- Overview of DuckDB Internals – DuckDB 8698
- 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
...Overview of DuckDB Internals On this page is a brief description of the internals of the DuckDB engine. Parser The parser converts a query string into the following tokens: SQLStatement QueryNode TableRef ParsedExpression The parser is not aware of the...be transformed into multiple SQL statements in case the original query string contains multiple queries. Binder The binder converts all nodes into their bound equivalents. In the binder phase: The tables and columns are resolved using the catalog Types a...riter : Rewrites large static IN clauses to a MARK join or INNER join. Column Binding Resolver The column binding resolver converts logical BoundColumnRefExpresion nodes that refer to a column of a specific table into BoundReferenceExpression nodes that... - https://man.mtool.work/duckdb/1.3/internals/overview.html
- Numeric Functions – DuckDB 8040
- 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
...x) Rounds the number up. Alias of ceil . cos(x) Computes the cosine of x . cot(x) Computes the cotangent of x . degrees(x) Converts radians to degrees. divide(x, y) Alias for x // y . even(x) Round to next even number by rounding away from zero. exp(x) C...value of pi. pow(x, y) Computes x to the power of y . power(x, y) Alias of pow . Computes x to the power of y . radians(x) Converts degrees to radians. random() Returns a random number x in the range 0.0 <= x < 1.0 . round_even(v NUMERIC, s INTEGER) Alia...61291701 cot(x) Description Computes the cotangent of x . Example cot(0.5) Result 1.830487721712452 degrees(x) Description Converts radians to degrees. Example degrees(pi()) Result 180 divide(x, y) Description Alias for x // y . Example divide(5, 2) Resu... - https://man.mtool.work/duckdb/1.3/sql/functions/numeric.html
- Conversion between DuckDB and Python – DuckDB 7901
- 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
...omes TIMESTAMP . datetime.time If the time has tzinfo, we will use TIMETZ , otherwise it becomes TIME . datetime.date date converts to the DATE type. We check against datetime.date.min and datetime.date.max to convert to -inf and +inf respectively. bytes...bytes converts to BLOB by default, when it's used to construct a Value object of type BITSTRING , it maps to BITSTRING instead. list list...─────────────────────────────────────────────────────────┘ Every key of the dictionary is converted to string. tuple tuple converts to LIST by default, when it's used to construct a Value object of type STRUCT it will convert to STRUCT instead. numpy.nda... - https://man.mtool.work/duckdb/1.3/clients/python/conversion.html
- Types – DuckDB 7815
- 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
...TYPE_TIMESTAMP_NS column. Return Value True if the timestamp is finite, false if it is ±infinity. duckdb_hugeint_to_double Converts a duckdb_hugeint object (as obtained from a DUCKDB_TYPE_HUGEINT column) into a double. Syntax double duckdb_hugeint_to_dou...kdb_hugeint val ); Parameters val : The hugeint value. Return Value The converted double element. duckdb_double_to_hugeint Converts a double value to a duckdb_hugeint object. If the conversion fails because the double value is too big the result will be...uble val ); Parameters val : The double value. Return Value The converted duckdb_hugeint element. duckdb_double_to_decimal Converts a double value to a duckdb_decimal object. If the conversion fails because the double value is too big, or the width/scale... - https://man.mtool.work/duckdb/1.3/clients/c/types.html
- Pivot Internals – DuckDB 7815
- 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
...her performance. Each PIVOT is implemented as set of aggregations into lists and then the dedicated PhysicalPivot operator converts those lists into column names and values. Additional pre-processing steps are required if the columns to be created when p...attle [2000, 2010, 2020] [564, 608, 738] US New York City [2000, 2010, 2020] [8015, 8175, 8772] The PhysicalPivot operator converts those lists into column names and values to return this result: country name 2000 2010 2020 NL Amsterdam 1005 1065 1158 US... - https://man.mtool.work/duckdb/1.3/internals/pivot.html
- Date Format Functions – DuckDB 7711
- 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
...at string that describes how the date or timestamp should be structured. strftime Examples The strftime(timestamp, format) converts timestamps or dates to strings according to the specified pattern. SELECT strftime ( DATE '1992-03-02' , '%d/%m/%Y' ); 02/...'%A, %-d %B %Y - %I:%M:%S %p' ); Monday, 2 March 1992 - 08:32:45 PM strptime Examples The strptime(text, format) function converts strings to timestamps according to the specified pattern. SELECT strptime ( '02/03/1992' , '%d/%m/%Y' ); 1992-03-02 00:00:... - https://man.mtool.work/duckdb/1.3/sql/functions/dateformat.html
DuckDB 1.3 Documentation / man.mtool.work