Results of 1 - 10 of about 12 for calendar (0.002 sec.)
- Timestamp Types 13955
- 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
...g instants into years, months and days. Temporal binning rules are complex, and generally come in two sets: time zones and calendars . For most tasks, the calendar will just be the widely used Gregorian calendar, but time zones apply locale-specific rule...another range of bins containing the offset from UTC is needed: Time Zone Support The TIMESTAMPTZ type can be binned into calendar and clock bins using a suitable extension. The built-in icu extension implements all the binning and arithmetic functions...using time zone data built from the IANA Time Zone Database and its own calendar implementation. Despite its name, the icu extension no longer depends on the International Components for Unicode (ICU) li... - https://man.mtool.work/duckdb/2.0/sql/data_types/timestamp.html
- Date Types 10630
- Name Aliases Description DATE Calendar date (year, month, day) A date specifies a combination of year, month and day. DuckDB follows the SQL standard's lead by counting dates exclusively in the Gregorian calendar, even for years before that
...calendar was in use. Dates can be created using the DATE keyword, where the data must be formatted according to the ISO 8601 format... - https://man.mtool.work/duckdb/2.0/sql/data_types/date.html
- Timestamp Issues 9215
- Timestamp with Time Zone Promotion Casts Working with time zones in SQL can be quite confusing at times. For example, when filtering to a date range, one might try the following query: SET timezone = 'America/Los_Angeles'; CREATE TABLE time
...0, the extension no longer depends on the International Components for Unicode (ICU) library: it implements time zones and calendars natively, using time zone data built from the IANA time zone database . This implementation supports daylight savings tim...thmetic on plain TIMESTAMP s. If the same temporal bins are computed repeatedly, one workaround is to precompute them in a calendar table for the timestamps being modeled. For example, if the application is modeling electrical supply and demand out to 21...00 at hourly resolution, one can create the calendar table like so: SET timezone = 'Europe/Amsterdam'; CREATE OR REPLACE TABLE hourly AS SELECT ts, year::SMALLINT AS year, mon... - https://man.mtool.work/duckdb/2.0/guides/sql_features/timestamps.html
- Timestamp with Time Zone Functions 9126
- 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
...e examples below, the current time zone is presumed to be America/Los_Angeles using the Gregorian calendar. Built-In Timestamp with Time Zone Functions The table below shows the available scalar functions for TIMESTAMPTZ values....m infinite values produces the same infinite value. Addition and subtraction of intervals follows the semantics of the ICU Calendar add function , which the icu extension implements natively since DuckDB 2.0. For positive intervals (forwards in time) the...ecremented from least to most significant. This produces the same results as Postgres, but does not match some more recent calendar RFCs . ICU Timestamp with Time Zone Functions The table below shows the ICU provided scalar functions for TIMESTAMP WITH T... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamptz.html
- ICU Extension 8472
- The icu extension provides collation, time zone, and calendar support. New In DuckDB 2.0, the dependency on the external ICU library was removed. The icu extension now implements collations, time zones, and calendars natively, with time zon
... - https://man.mtool.work/duckdb/2.0/core_extensions/icu.html
- Date Part Functions 8136
- 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
...ear (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(date) ISO Year number (Starts on...on | Seconds since 1970-01-01. | | Example | epoch(DATE '1992-02-15') | | Result | 698112000.0 | era(date) | Description | Calendar era. | | Example | era(DATE '0044-03-15 (BC)') | | Result | 0 | hour(date) | Description | Hours. | | Example | hour(times... - https://man.mtool.work/duckdb/2.0/sql/functions/datepart.html
- Configuration 7977
- DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi
...s a list of all available configuration options by scope. Global Configuration Options Name Description Type Default value Calendar The current calendar VARCHAR System (locale) calendar TimeZone The current time zone VARCHAR System (locale) timezone acce... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- Data Types 7800
- General-Purpose Data Types The table below shows all the built-in general-purpose data types. The alternatives listed in the aliases column can be used to refer to these types as well, however, note that the aliases are not part of the SQL
...RY Variable-length binary data BIGNUM Variable-length integer BOOLEAN BOOL , LOGICAL Logical Boolean ( true / false ) DATE Calendar date (year, month, day) DECIMAL(prec, scale) NUMERIC(prec, scale) Fixed-precision number with the given width (precision)... - https://man.mtool.work/duckdb/2.0/sql/data_types/overview.html
- What's New in the Docs for 2.0 7800
- This page tracks the documentation for the features introduced in DuckDB 2.0, organized around the themes of the DuckDB 2.0.0 release announcement . Each section links to the relevant documentation. DuckDB as a Server: Quack and CONNECT Sin
...llows extensions to contribute grammar. PEG parser Legacy parser extension for switching back to the old parser Timezones, Calendars and Collations Without ICU DuckDB 2.0 replaces the ICU library with a smaller, faster native implementation of timezone,... - https://man.mtool.work/duckdb/2.0/whats_new_in_the_docs.html
- Friendly SQL 7711
- DuckDB offers several advanced SQL features and syntactic sugar to make SQL queries more concise. We refer to these colloquially as “friendly SQL”. Several of these features were first introduced by DuckDB, while some are inspired by other
...nally introduced by DuckDB (e.g., GROUP BY ALL ) have been since adapted by other systems. Tip We have a Friendly SQL 2026 Calendar with a short explanation, an example, and an abstract illustration for 12 friendly SQL features. Clauses Creating tables a... - https://man.mtool.work/duckdb/2.0/sql/dialect/friendly_sql.html
DuckDB 2.0 Documentation / man.mtool.work