Results of 1 - 10 of about 38 for converted (0.004 sec.)
- Values 14104
- The value class represents a single value of any type. API Reference Overview void duckdb_destroy_value ( duckdb_value * value ); duckdb_value duckdb_create_varchar ( const char * text ); duckdb_value duckdb_create_varchar_length ( const ch
..._value val ); Parameters val : A duckdb_value containing a boolean Return Value A boolean, or false if the value cannot be converted duckdb_get_int8 Returns the int8_t value of the given value. Syntax int8_t duckdb_get_int8 ( duckdb_value val ); Parameter...s val : A duckdb_value containing a tinyint Return Value A int8_t, or MinValue if the value cannot be converted duckdb_get_uint8 Returns the uint8_t value of the given value. Syntax uint8_t duckdb_get_uint8 ( duckdb_value val ); Param...eters val : A duckdb_value containing a utinyint Return Value A uint8_t, or MinValue if the value cannot be converted duckdb_get_int16 Returns the int16_t value of the given value. Syntax int16_t duckdb_get_int16 ( duckdb_value val ); Param... - https://man.mtool.work/duckdb/2.0/clients/c/value.html
- Complete API 13915
- This page contains the reference for DuckDB's C API. The reference contains several deprecation notices. These concern methods whose long-term availability is not guaranteed as they may be removed in the future. That said, DuckDB's develope
...); duckdb_error_data duckdb_schema_from_arrow ( duckdb_connection connection , struct ArrowSchema * schema , duckdb_arrow_converted_schema * out_types ); duckdb_error_data duckdb_data_chunk_from_arrow ( duckdb_connection connection , struct ArrowArray *...arrow_array , duckdb_arrow_converted_schema converted_schema , duckdb_data_chunk * out_chunk ); void duckdb_destroy_arrow_converted_schema ( duckdb_arrow_conve...rted_schema * arrow_converted_schema ); duckdb_state duckdb_query_arrow ( duckdb_connection connection , const char * query , duckdb_arrow * out_result... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
- Literal Types 8994
- DuckDB has special literal types for representing NULL , integer and string literals in queries. These have their own binding and conversion rules. Prior to DuckDB version 0.10.0, integer and string literals behaved identically to the INTEG
...ER and VARCHAR types. Null Literals The NULL literal is denoted with the keyword NULL . The NULL literal can be implicitly converted to any other type. Integer Literals Integer literals are denoted as a sequence of one or more decimal digits. At runtime,...these result in values of the INTEGER_LITERAL type. INTEGER_LITERAL types can be implicitly converted to any integer type in which the value fits. For example, the integer literal 42 can be implicitly converted to a TINYINT...and does not work with other kinds of string values. Implicit String Conversion STRING_LITERAL instances can be implicitly converted to any other type. For example, we can compare string literals with dates: SELECT d > '1992-01-01' AS result FROM (VALUES... - https://man.mtool.work/duckdb/2.0/sql/data_types/literal_types.html
- Creating JSON 8711
- JSON Creation Functions The following functions are used to create JSON. Function Description to_json(any) Create JSON from a value of any type. Our LIST is converted to a JSON array, and our STRUCT and MAP are converted to a JSON object. j
... - https://man.mtool.work/duckdb/2.0/data/json/creating_json.html
- Excel Export 8443
- DuckDB supports exporting data to Excel .xlsx files via the excel extension. Please note that .xls files are not supported. To install and load the extension, run: INSTALL excel; LOAD excel; Exporting Excel Sheets To export a table to an Ex
...y applied when writing XLSX files: Numeric types are cast to DOUBLE . Temporal types ( TIMESTAMP , DATE , TIME , etc.) are converted to Excel "serial" numbers, that is the number of days since 1900-01-01 for dates and the fraction of a day for times. Thes...MP_TZ and TIME_TZ are cast to UTC TIMESTAMP and TIME respectively, with the timezone information being lost. BOOLEAN s are converted to 1 and 0 , with a "number format" applied to make them appear as TRUE and FALSE in Excel. All other types are cast to VA... - https://man.mtool.work/duckdb/2.0/guides/file_formats/excel_export.html
- Timestamp Types 8443
- Timestamps represent points in time. As such, they combine DATE and TIME information. They can be created using the type name followed by a string formatted according to the ISO 8601 format, YYYY-MM-DD hh:mm:ss[.zzzzzzzzz][+-TT[:tt]] , whic
...djustedToUTC=true , are now read as TIMESTAMPTZ_NS and retain their full precision. In earlier versions these columns were converted to TIMESTAMP WITH TIME ZONE and lost precision. SELECT TIMESTAMP_NS '1992-09-20 11:30:00.123456789'; 1992-09-20 11:30:00.1...biguous, but requires the ICU extension to handle time zone names. When strings without UTC offsets or time zone names are converted to a WITH TIME ZONE type, the string is interpreted in the configured time zone. When strings with UTC offsets are passed...(in earlier versions, names other than UTC raised an error). Finally, when WITH TIME ZONE and WITHOUT TIME ZONE types are converted to each other via explicit or implicit casts, the translation uses the configured time zone. To use an alternative time zo... - https://man.mtool.work/duckdb/2.0/sql/data_types/timestamp.html
- Excel Extension 8349
- The excel extension provides functions to format numbers per Excel's formatting rules by wrapping the i18npool library and to read/write Excel ( .xlsx ) files. However, please note that .xls files are not supported. Installing and Loading T
...of the resulting columns are determined by the types of the columns in the table being copied to. All cells will simply be converted by casting from DOUBLE or VARCHAR to the target column type. Writing XLSX Files Writing .xlsx files is supported using the...files. Numeric types are cast to DOUBLE when writing to an XLSX file. Temporal types ( TIMESTAMP , DATE , TIME , etc.) are converted to excel "serial" numbers, that is the number of days since 1900-01-01 for dates and the fraction of a day for times. Thes...MP_TZ and TIME_TZ are cast to UTC TIMESTAMP and TIME respectively, with the timezone information being lost. BOOLEAN s are converted to 1 and 0 , with a "number format" applied to make them appear as TRUE and FALSE in Excel. All other types are cast to VA... - https://man.mtool.work/duckdb/2.0/core_extensions/excel.html
- Executing SQL in Python 8349
- SQL queries can be executed using the duckdb.sql function. import duckdb duckdb.sql("SELECT 42").show() By default this will create a relation object. The result can be converted to various formats using the result conversion functions. For
...s list or dictionary is copied when sql is called, together with any list, tuple or dictionary inside it. Other values are converted each time the relation is read, so a bytearray changed in place afterwards is read changed. To run the same parameterized... - https://man.mtool.work/duckdb/2.0/guides/python/execute_sql.html
- Integration with PyTorch 8349
- PyTorch tensors can be built from DuckDB query results by exporting each result batch as Apache Arrow . This pattern is useful when training or serving models on Parquet data because DuckDB can filter and project the input before the batche
...s are converted to tensors. Installation pip install -U duckdb numpy pyarrow torch DuckDB to PyTorch This example queries a Parquet-backed...shes the WHERE label = 1 filter and the selected columns into the dataset scan, so only the requested rows and columns are converted to tensors. The to_arrow_reader method of a relation streams the result in batches instead of materializing the full resul... - https://man.mtool.work/duckdb/2.0/guides/python/pytorch.html
- Export to Pandas 8160
- The result of a query can be converted to a Pandas DataFrame using the df() function. import duckdb # read the result of an arbitrary SQL query to a Pandas DataFrame results = duckdb.sql("SELECT 42").df() results 42 0 42 See Also DuckDB als
... - https://man.mtool.work/duckdb/2.0/guides/python/export_pandas.html
DuckDB 2.0 Documentation / man.mtool.work