Results of 1 - 10 of about 66 for since (0.002 sec.)
- Timestamp Functions 14526
- 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
...ision . dayname(timestamp) The (English) name of the weekday. epoch_ms(timestamp) Returns the total number of milliseconds since the epoch. epoch_ns(timestamp) Returns the total number of nanoseconds since the epoch. epoch_us(timestamp) Returns the to...tal number of microseconds since the epoch. epoch(timestamp) Returns the total number of seconds since the epoch. extract(field FROM timestamp) Get subfiel...int, bigint, bigint, bigint, double) The timestamp for the given parts. make_timestamp(microseconds) Converts microseconds since the epoch to a timestamp. make_timestamp_ms(milliseconds) Converts milliseconds since the epoch to a timestamp. make_times... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamp.html
- Timestamp with Time Zone Functions 11144
- 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
.... Built-In Timestamp with Time Zone Functions The table below shows the available scalar functions for TIMESTAMPTZ values. Since these functions do not involve binning or display, they are always available. Name Description current_timestamp Current d...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 time zone. transaction_timestamp() Current date and time (start of current transaction). cur...able('18:18:16.21-07:00'::TIMETZ) | | Result | 2494691656335442799 | to_timestamp(double) | Description | Converts seconds since the epoch to a timestamp with time zone. | | Example | to_timestamp(1284352323.5) | | Result | 2010-09-12 21:32:03.5-07 |... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamptz.html
- Delta Extension 10702
- The delta extension adds support for the Delta Lake open-source storage format . It is built using the Delta Kernel . The extension reads Delta tables, local and remote, and writes them: it can create tables and append to them. For implemen
...e INSERT INTO : ATTACH 's3://⟨my_bucket⟩/⟨path⟩' AS my_table (TYPE delta); INSERT INTO my_table SELECT * FROM other_table; Since v1.5.6, if the table schema declares CHAR(n) or VARCHAR(n) (Spark writes these), a write with a value longer than n charac...'2026-09-01 12:00:00+00'); -- Scan without attaching SELECT * FROM delta_scan('s3://⟨my_bucket⟩/⟨path⟩', version => 5); -- since v1.5.4 SELECT * FROM delta_scan('s3://⟨my_bucket⟩/⟨path⟩', timestamp => TIMESTAMPTZ '2026-09-01 12:00:00+00'); A table att...t a time zone uses the session's TimeZone . Within a transaction, a timestamp always reads the same version. Checkpointing Since v1.5.1, CHECKPOINT compacts the Delta log of an attached table into a checkpoint file, which speeds up reads of tables wit... - https://man.mtool.work/duckdb/2.0/core_extensions/delta.html
- Unity Catalog Extension 10545
- The unity_catalog extension attaches a Unity Catalog catalog, on Databricks or Unity Catalog OSS, as a DuckDB database. You can list, read, insert into and create its Delta Lake tables. It uses the delta extension to access the tables. For
...atalog.my_schema.my_table SELECT * FROM other_table; Data Types Unity Catalog column types map to DuckDB types as follows. Since v1.5.6, DuckDB reads them from the table's Delta log. timestamp maps to TIMESTAMP WITH TIME ZONE and, since v1.5.6, timest...amp_ntz to TIMESTAMP . Since v1.5.6, a column of a type that DuckDB cannot read is listed with the type UNKNOWN , e.g., in DESCRIBE . Reading the table...s the table while CREATE TABLE runs, so a ROLLBACK of the surrounding transaction does not remove the table. Checkpointing Since v1.5.1, unity_catalog_checkpoint_table compacts the Delta log of a table into a checkpoint file, which speeds up reads of... - https://man.mtool.work/duckdb/2.0/core_extensions/unity_catalog.html
- Graph Queries 9375
- DuckDB supports graph queries via the DuckPGQ community extension , which implements the SQL/PGQ syntax from the SQL:2023 standard. Warning DuckPGQ is a community extension and is still under active development. It may not be available for
...existing tables: CREATE TABLE Person (id BIGINT, name VARCHAR); CREATE TABLE Knows (person1_id BIGINT, person2_id BIGINT, since DATE); INSERT INTO Person VALUES (1, 'Alice'), (2, 'Bob'), (3, 'Charlie'); INSERT INTO Knows VALUES (1, 2, '2020-01-01'),...: FROM GRAPH_TABLE (social_network MATCH (a:Person)-[k:Knows]->(b:Person) COLUMNS (a.name AS person1, b.name AS person2, k.since) ); person1 person2 since Alice Bob 2020-01-01 Bob Charlie 2021-06-15 Path Finding Find paths of variable length using qua... - https://man.mtool.work/duckdb/2.0/guides/sql_features/graph_queries.html
- Date Part Functions 8932
- The date_part , date_trunc and date_diff functions can be used to extract or manipulate parts of temporal types such as TIMESTAMP , TIMESTAMPTZ , DATE and INTERVAL . The parts to be extracted or manipulated are specified by one of the strin
...VAL s or used to construct them. Except for julian and epoch , which return DOUBLE s, all parts are extracted as integers. Since there are no infinite integer values in DuckDB, NULL s are returned for infinite timestamps. Part Specifiers Usable as Dat...eek Day of the week (Sunday = 0, Saturday = 6) weekday , dow 2 dayofyear Day of the year (1-365/366) doy 215 epoch Seconds since 1970-01-01 1627991984.123456 era Gregorian era (CE/AD, BCE/BC) 1 isodow ISO day of the week (Monday = 1, Sunday = 7) 2 iso...dayofyear(date) Day of the year (starts from 1, i.e., January 1 = 1). decade(date) Decade (year / 10). epoch(date) Seconds since 1970-01-01. era(date) Calendar era. hour(date) Hours. isodow(date) Numeric ISO weekday (Monday = 1, Sunday = 7). isoyear(d... - https://man.mtool.work/duckdb/2.0/sql/functions/datepart.html
- Union Type 8790
- A UNION type (not to be confused with the SQL UNION operator ) is a nested type capable of holding one of multiple “alternative” values, much like the union in C. The main difference is that these UNION types are tagged unions and thus alwa
...rtype” relationship with their members. Thus UNION types can't be implicitly cast to any of their member types in general, since the information in the other members not matching the target type would be “lost”. If you want to coerce a UNION into one...ion to this is when casting a UNION to VARCHAR , in which case the members will all use their corresponding VARCHAR casts. Since everything can be cast to VARCHAR , this is “safe” in a sense. Casting to Unions A type can always be implicitly cast to a...UNION(a A, b B) UNION(a A, b C) if B can't be implicitly cast to C ❌ UNION(A, B, D) UNION(A, B, C) Comparison and Sorting Since UNION types are implemented on top of STRUCT types internally, they can be used with all the comparison operators as well... - https://man.mtool.work/duckdb/2.0/sql/data_types/union.html
- Enum Data Type 8490
- Name Description ENUM Dictionary representing all possible string values of a column The enum type represents a dictionary data structure with all possible unique values of a column. For example, a column storing the days of the week can be
...ou can create an enum using hardcoded values: CREATE TYPE mood AS ENUM ('sad', 'ok', 'happy'); -- This statement will fail since enums cannot hold NULL values: -- CREATE TYPE mood AS ENUM ('sad', NULL); -- This statement will fail since enum values mu...erson VALUES ('Pedro', 'happy'), ('Mark', NULL), ('Pagliacci', 'sad'), ('Mr. Mackey', 'ok'); The following query will fail since the mood type does not have a quackity-quack value. INSERT INTO person VALUES ('Hannes', 'quackity-quack'); Enums vs. Stri... - https://man.mtool.work/duckdb/2.0/sql/data_types/enum.html
- PostgreSQL Compatibility 8205
- DuckDB's SQL dialect closely follows the conventions of the PostgreSQL dialect. The few exceptions to this are listed on this page. Floating-Point Arithmetic DuckDB and PostgreSQL handle floating-point arithmetic differently for division by
...is behavior was problematic when interfacing with other tools (e.g., Parquet, Pandas) that are case-sensitive by default – since all identifiers would be lowercased all the time. Therefore, DuckDB achieves case insensitivity by making identifiers full...nt is only used to rebuild statistics. For instruction on reclaiming space, refer to the “Reclaiming space” page . Strings Since version 1.3.0, DuckDB escapes characters such as ' in strings serialized in nested data structures. PostgreSQL does not do...se use the strptime function . date_part Function Most parts extracted by the date_part function are returned as integers. Since there are no infinite integer values in DuckDB, NULL s are returned for infinite timestamps. pg_size_pretty Function DuckD... - https://man.mtool.work/duckdb/2.0/sql/dialect/postgresql_compatibility.html
- Reading and Writing Parquet Files 7605
- Examples Read a single Parquet file: SELECT * FROM 'test.parquet'; Figure out which columns/types are in a Parquet file: DESCRIBE SELECT * FROM 'test.parquet'; Create a table from a Parquet file: CREATE TABLE test AS SELECT * FROM 'test.par
...l column that specifies which file each row came from (this column is available by default without a configuration options since DuckDB 1.3.0): SELECT *, filename FROM read_parquet('test/*.parquet'); Use a list of globs to read all Parquet files from...in NaN values. When set to true, the reader accounts for NaN when using a column's min/max statistics for filter pushdown, since NaN does not compare as ordered. BOOL false encryption_config Configuration for Parquet encryption . STRUCT - filename Whe...ther or not an extra filename column should be included in the result. Since DuckDB 1.3.0, the filename column is added automatically as a virtual column and this option is only kept for compatibilit... - https://man.mtool.work/duckdb/2.0/data/parquet/overview.html
DuckDB 2.0 Documentation / man.mtool.work