Results of 1 - 10 of about 12 for datetime (0.005 sec.)
- Conversion between DuckDB and Python – DuckDB 14008
- 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: Python Object to DuckDB This is a mapping of Python object types to DuckDB Logical Types : None → NULL bool → BOOLEAN datetime.timedelta → INTERVAL str → VARCHAR bytearray → BLOB memoryview → BLOB decimal.Decimal → DECIMAL / DOUBLE uuid.UUID → UUID...a target type, which will influence the conversion. float These casts are tried in order until one succeeds: DOUBLE FLOAT datetime.datetime For datetime we will check pandas.isnull if it's available and return NULL if it returns true . We check against...datetime.datetime.min and datetime.datetime.max to convert to -inf and +inf respectively. If the datetime has tzinfo, we will use TIMESTAMPT... - https://man.mtool.work/duckdb/1.3/clients/python/conversion.html
- Python Function API – DuckDB 10524
- 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
...ython partial functions . In the below example, we show how a custom logger will return the concatenation of the execution datetime in ISO format, always followed by argument passed at UDF creation and the input parameter provided to the function call: f...rom datetime import datetime import duckdb import functools def get_datetime_iso_format () -> str : return datetime . now (). isoformat...tbl(id)" ). to_table ( "example_table" ) con . create_function ( 'custom_logger' , functools . partial ( logger_udf , get_datetime_iso_format , 'logging data' ) ) rel = con . sql ( "SELECT custom_logger(id) from example_table;" ) rel . show () con . cre... - https://man.mtool.work/duckdb/1.3/clients/python/function.html
- Schema – DuckDB 9604
- 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
...Performance Copy Markdown Schema Types It is important to use the correct type for encoding columns (e.g., BIGINT , DATE , DATETIME ). While it is always possible to use string types ( VARCHAR , etc.) to encode more specific values, this is not recommend...ple aggregation query that returns the average day-of-the month from the timestamps in two configurations. First, we use a DATETIME to encode the values and run the query using the extract datetime function : SELECT avg ( extract ( 'day' FROM creationDat...: 10 ] AS INTEGER )) FROM Comment ; The results of the microbenchmark are as follows: Column type Storage size Query time DATETIME 3.3 GB 0.9 s VARCHAR 5.2 GB 3.9 s The results show that using the DATETIME value yields smaller storage sizes and faster p... - https://man.mtool.work/duckdb/1.3/guides/performance/schema.html
- Indexing – DuckDB 8684
- 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
...ns when inserting it. Even an imperfect ordering will still be helpful. The best case of ordered data commonly arises with DATETIME columns. Microbenchmark: The Effect of Ordering For an example, let's repeat the microbenchmark for timestamps with an ord...ered timestamp column using an ascending order vs. an unordered one. Column type Ordered Storage size Query time DATETIME yes 1.3 GB 0.6 s DATETIME no 3.3 GB 0.9 s The results show that simply keeping the column order allows for improved compre... - https://man.mtool.work/duckdb/1.3/guides/performance/indexing.html
- Relational API – DuckDB 8295
- 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
...ption', 'STRING', None, None, None, None, None), ('value', 'NUMBER', None, None, None, None, None), ('created_timestamp', 'DATETIME', None, None, None, None, None)] dtypes Description Return a list containing the types of the columns of the relation. Ali...Parameters values : object A tuple of values matching the relation column list, to be inserted. Example import duckdb from datetime import datetime from uuid import uuid4 duckdb_conn = duckdb . connect () duckdb_conn . sql ( """ select gen_random_uuid()...to_table ( "code_example" ) rel = duckdb_conn . table ( "code_example" ) rel . insert ( ( uuid4 (), 'value is even' , 10 , datetime . now () ) ) rel . filter ( "value = 10" ) Result ┌──────────────────────────────────────┬───────────────┬───────┬────────... - https://man.mtool.work/duckdb/1.3/clients/python/relational_api.html
- Date Functions – DuckDB 8136
- 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 parentheses should be omitted from the function call. date_add(date, interval) Add the interval to the date and return a DATETIME value. date_diff(part, startdate, enddate) The number of partition boundaries between the dates. date_part(part, date) Get...all. Example current_date Result 2022-10-08 date_add(date, interval) Description Add the interval to the date and return a DATETIME value. Example date_add(DATE '1992-09-15', INTERVAL 2 MONTH) Result 1992-11-15 00:00:00 date_diff(part, startdate, enddate... - https://man.mtool.work/duckdb/1.3/sql/functions/date.html
- My Workload Is Slow – DuckDB 7994
- 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
...ing them , which boosts load and update performance. Are you using the correct types? For example, use TIMESTAMP to encode datetime values . Are you reading from Parquet files? If so, do they have row group sizes between 100k and 1M and file sizes betwee... - https://man.mtool.work/duckdb/1.3/guides/performance/my_workload_is_slow.html
- Data Types – DuckDB 7835
- 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
...(no time zone) TIMESTAMP WITH TIME ZONE TIMESTAMPTZ Combination of time and date that uses the current time zone TIMESTAMP DATETIME Combination of time and date TINYINT INT1 Signed one-byte integer UBIGINT Unsigned eight-byte integer UHUGEINT Unsigned si... - https://man.mtool.work/duckdb/1.3/sql/data_types/overview.html
- Timestamp Types – DuckDB 7747
- 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 are ignored. Timestamp Types Name Aliases Description TIMESTAMP_NS Naive timestamp with nanosecond precision TIMESTAMP DATETIME , TIMESTAMP WITHOUT TIME ZONE Naive timestamp with microsecond precision TIMESTAMP_MS Naive timestamp with millisecond pre... - https://man.mtool.work/duckdb/1.3/sql/data_types/timestamp.html
- Text Functions – DuckDB 7747
- 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
...+ {} = {}' , 3 , 5 , 3 + 5 ); -- 3 + 5 = 8 Booleans: SELECT format ( '{} != {}' , true , false ); -- true != false Format datetime values: SELECT format ( '{}' , DATE '1992-01-01' ); -- 1992-01-01 SELECT format ( '{}' , TIME '12:01:00' ); -- 12:01:00 SE...+ %d = %d' , 3 , 5 , 3 + 5 ); -- 3 + 5 = 8 Booleans: SELECT printf ( '%s != %s' , true , false ); -- true != false Format datetime values: SELECT printf ( '%s' , DATE '1992-01-01' ); -- 1992-01-01 SELECT printf ( '%s' , TIME '12:01:00' ); -- 12:01:00 SE... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
DuckDB 1.3 Documentation / man.mtool.work