Results of 1 - 10 of about 71 for Part (0.002 sec.)
- Time Functions 13100
- This section describes functions and operators for examining and manipulating TIME values . Time Operators The table below shows the available mathematical operators for TIME types. Operator Description Example Result + addition of an INTER
...ltime() Current time (start of current transaction) in the local time zone, as a TIME value without a time zone. date_diff(part, starttime, endtime) The number of part boundaries between starttime and endtime , inclusive of the larger time and exclus...ive of the smaller time. date_part(part, time) Get subfield (equivalent to extract ). date_sub(part, starttime, endtime) The signed length of the interval be...tween starttime and endtime , truncated to whole multiples of part . extract(part FROM time) Get subfield from a time. get_current_time() Current time (start of current transaction). make_t... - https://man.mtool.work/duckdb/2.0/sql/functions/time.html
- Date Functions 11835
- This section describes functions and operators for examining and manipulating DATE values. Date Operators The table below shows the available mathematical operators for DATE types. Operator Description Example Result + addition of days (int
...e promotion. Name Description date_add(date, interval) Add the interval to the date and return a DATETIME value. date_diff(part, startdate, enddate) The number of part boundaries between startdate and enddate , inclusive of the larger date and exclus...ive of the smaller date. date_part(part, date) Get subfield (equivalent to extract ). date_sub(part, startdate, enddate) The signed length of the interval be...tween startdate and enddate , truncated to whole multiples of part . date_trunc(part, date) Truncate to specified precision . dayname(date) The (English) name of the weekday. days_in_month(... - https://man.mtool.work/duckdb/2.0/sql/functions/date.html
- Interval Functions 11511
- This section describes functions and operators for examining and manipulating INTERVAL values. Interval Operators The table below shows the available mathematical operators for INTERVAL types. Operator Description Example Result + Addition
...01:02:03 Interval Functions The table below shows the available scalar functions for INTERVAL types. Name Description date_part(part, interval) Extract datepart component (equivalent to extract ). See INTERVAL for the sometimes surprising rules gover...ning this extraction. datepart(part, interval) Alias of date_part . extract(part FROM interval) Alias of date_part . epoch(interval) Get total number of...terval. to_weeks(integer) Construct a week interval. to_years(integer) Construct a year interval. Only the documented date part components are defined for intervals. date_part(part, interval) | Description | Extract datepart component (equivalent to... - https://man.mtool.work/duckdb/2.0/sql/functions/interval.html
- Timestamp Functions 10963
- 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
...entury of a timestamp. current_localtimestamp() Returns the current timestamp (at the start of the transaction). date_diff(part, starttimestamp, endtimestamp) The number of part boundaries between starttimestamp and endtimestamp , inclusive of the la...rger timestamp and exclusive of the smaller timestamp. date_part([part, ...], timestamp) Get the listed subfields as a struct . The list must be constant. date_part(part, timestamp) Get s...ubfield (equivalent to extract ). date_sub(part, starttimestamp, endtimestamp) The signed length of the interval between starttimestamp and endtimestamp , truncated to wh... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamp.html
- Timestamp with Time Zone Functions 10795
- 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
...ments, resulting in the time difference between the two timestamps. age(timestamptz) Subtract from current_date. date_diff(part, starttimestamptz, endtimestamptz) The number of part boundaries between starttimestamptz and endtimestamptz inclusive of...the larger timestamp and exclusive of the smaller timestamp. date_part([part, ...], timestamp) Get the listed subfields as a struct . The list must be constant. date_part(part, timestamp) Get s...ubfield (equivalent to extract ). date_sub(part, starttimestamptz, endtimestamptz) The signed length of the interval between starttimestamptz and endtimestamptz , truncat... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamptz.html
- Literal Types 8532
- 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
...on-integer numeric literals can be denoted with decimal notation, using the period character ( . ) to separate the integer part and the decimal part of the number. Either the integer part or the decimal part may be omitted: SELECT 1.5; -- 1.5 SELECT...literals can also be denoted using E notation . In E notation, an integer or decimal literal is followed by an exponential part, which is denoted by e or E , followed by a literal integer indicating the exponent. The exponential part indicates that t...01'::INTEGER . Underscores cannot be the first or last character in a literal. Underscores have to have an integer/numeric part on either side of them, i.e., there cannot be multiple underscores in a row and underscores cannot appear immediately befo... - https://man.mtool.work/duckdb/2.0/sql/data_types/literal_types.html
- Interval Type 8363
- INTERVAL s represent periods of time that can be added to or subtracted from DATE , TIMESTAMP , TIMESTAMPTZ , or TIME values. Name Description INTERVAL Period of time An INTERVAL can be constructed by providing amounts together with units.
...QL query: SELECT DATE '2000-01-01' + INTERVAL (i) MONTH FROM range(12) t(i); When INTERVAL s are deconstructed via the datepart function, the months component is additionally split into years and months, and the microseconds component is split into h...ates an INTERVAL called period by summing random amounts of the three basis units. It then extracts the aforementioned six parts from period , adds them back together, and confirms that the result is always equal to the original period . SELECT perio...d = list_reduce( [INTERVAL (datepart(part, period) || part) FOR part IN ['year', 'month', 'day', 'hour', 'minute', 'microsecond'] ], lambda i1, i2: i1 + i2 ) -... - https://man.mtool.work/duckdb/2.0/sql/data_types/interval.html
- S3 API Support 8265
- The httpfs extension supports reading/writing/ globbing files on object storage servers using the S3 API. S3 offers a standard API to read and write to remote files (while regular http servers, predating S3, do not offer a common write API)
...are R2 , SeaweedFS , and Tigris ) should also work, but not all features may be supported. The following table shows which parts of the S3 API are required for each httpfs feature. Feature Required S3 API features Public file reads HTTP Range request...s Private file reads Secret key or session token authentication File glob ListObjectsV2 File writes Multipart upload Configuration and Authentication Tip For an overview of the available methods and guidance on which one to use, see...⟩.parquet'); Reading Reading files from S3 is now as simple as: SELECT * FROM 's3://⟨your-bucket⟩/⟨filename⟩.⟨extension⟩'; Partial Reading The httpfs extension supports partial reading from S3 buckets. Pinning Object Versions By default, a long-runni... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api.html
- Directly Reading Files 7815
- DuckDB allows directly reading files via the read_text and read_blob functions. These functions accept a filename, a list of filenames, or a glob pattern. They output the content of each file as a VARCHAR or BLOB , respectively, along with
...t VARCHAR YES NULL NULL NULL size BIGINT YES NULL NULL NULL last_modified TIMESTAMP WITH TIME ZONE YES NULL NULL NULL Hive Partitioning Data can be read from Hive partitioned datasets. SELECT * FROM read_blob('data/parquet-testing/hive-partitioning/s...imple/**/*.parquet') WHERE part IN ('a', 'b') AND date >= '2012-01-01'; filename content size last_modified date part …/part=a/date=2012-01-01/test.parque...t PAR1\x15\x00\x15\x14\x15\x18… 266 2024-11-12 02:23:20+00 2012-01-01 a …/part=b/date=2013-01-01/test.parquet PAR1\x15\x00\x15\x14\x15\x18… 266 2024-11-12 02:23:20+00 2013-01-01 b Handling Missing Meta... - https://man.mtool.work/duckdb/2.0/guides/file_formats/read_file.html
- Date Part Functions 7815
- 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
...gs in the tables below. The example column provides the corresponding parts of the timestamp 2021-08-03 11:59:44.123456 . Only the entries of the first table can be extracted from INTERVAL s or use...d 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 timesta...mps. Part Specifiers Usable as Date Part Specifiers and in Intervals Specifier Description Synonyms Example century Gregorian centur... - https://man.mtool.work/duckdb/2.0/sql/functions/datepart.html
DuckDB 2.0 Documentation / man.mtool.work