Results of 1 - 10 of about 33 for time zone (0.002 sec.)
time (164), zone (35)
- Timestamp Types 23717
- 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
...h is also the format we use in this documentation. Decimal places beyond the supported precision 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 precision TIMESTAMP_S Naive...timestamp with second precision TIMESTAMPTZ TIMESTAMP WITH TIME ZONE Time zone aware timestamp with microsecond precision TIMESTAMPTZ_NS Time zone aware timestamp with nanosecond precision Ne... - https://man.mtool.work/duckdb/2.0/sql/data_types/timestamp.html
- Timestamp with Time Zone Functions 22782
- 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 t...able below shows the available scalar functions for TIMESTAMPTZ values. Since these functions do not involve binning or display, they are always available. Name Description curren...atest(timestamptz, timestamptz) The later of two timestamps. isfinite(timestamptz) Returns true if the timestamp with time zone is finite, false otherwise. isinf(timestamptz) Returns true if the timestamp with time zone is infinite, false otherwise.... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamptz.html
- Timestamp Issues 20256
- 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
...s AS FROM range('2025-08-30'::TIMESTAMPTZ, '2025-08-31'::TIMESTAMPTZ, INTERVAL 1 HOUR) tbl(t); FROM times WHERE t <= '2025-08-30'; ┌─────────────────────────...─┐ │ t │ │ timestamp with time zone │ ├──────────────────────────┤ │ 2025-08-30 00:00:00-07 │ └──────────────────────────┘ But if you chan...ge to another time zone, the results of the query change: SET timezone = 'HST'; FROM times WHERE t <= '2025-08-30'; ┌──────────────────────────┐ │... - https://man.mtool.work/duckdb/2.0/guides/sql_features/timestamps.html
- Time Functions 19242
- 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
...VAL TIME '01:02:03' + INTERVAL 5 HOUR 06:02:03 - subtraction of an INTERVAL TIME '06:02:03' - INTERVAL 5 HOUR 01:02:03 Time Functio...ns The table below shows the available scalar functions for TIME types. Name Description current_localtime() 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... - https://man.mtool.work/duckdb/2.0/sql/functions/time.html
- DuckLake 18636
- DuckLake 1.1 was released together with DuckDB 2.0. Read the announcement blog post . The ducklake extension adds support for attaching to databases stored in the DuckLake format . The complete documentation of this extension is available a
...─────┬────────────────┬──────────────────────────┬─────────┬────────────────┬───────────────────┐ │ snapshot_id │ snapshot_time │ schema_version │ changes │ author │ commit_message │ commit_extra_info │ │ int64 │ timestamp with time zone │ int64 │ ma...no The information is encoded into a table with the following schema: Column name Column type snapshot_id BIGINT snapshot_time TIMESTAMP WITH TIME ZONE schema_version BIGINT changes MAP(VARCHAR, VARCHAR[]) author VARCHAR commit_message VARCHAR commi...e function has two variants, depending on whether start_snapshot and end_snapshot have types BIGINT or TIMESTAMP WITH TIME ZONE . Parameter name Parameter type Named parameter Description catalog VARCHAR no schema_name VARCHAR no table_name VARCHAR n... - https://man.mtool.work/duckdb/2.0/core_extensions/ducklake.html
- Time Types 17598
- The TIME and TIMETZ types specify the hour, minute, second, microsecond of a day. Name Aliases Description TIME TIME WITHOUT TIME ZONE Time of day TIMETZ TIME WITH TIME ZONE Time of day, with time zone offset TIME_NS Time of day, nanosecond
...a keyword, where the data must be formatted according to the ISO 8601 format ( hh:mm:ss[.zzzzzz[zzz]][+-TT[:tt]] ). SELECT TIME '1992-09-20 11:30:00.123456'; 11:30:00.123456 SELECT TIMETZ '1992-09-20 11:30:00.123456'; 11:30:00.123456+00 SELECT TIMETZ...'1992-09-20 11:30:00.123456-02:00'; 13:30:00.123456+00 SELECT TIMETZ '1992-09-20 11:30:00.123456+05:30'; 06:00:00.123456+00 SELECT '15:30:00.123456789'::TIME_NS; 15:30:00.123456789 TIME_NS... - https://man.mtool.work/duckdb/2.0/sql/data_types/time.html
- Date Part Functions 17495
- 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 used to construc...ll 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 Date Part Specifiers and in Intervals Specifier Description Synonyms Example century Greg...soyear ISO Year number (Starts on Monday of week containing Jan 4th) 2021 julian Julian Day number. 2459430.4998162435 timezone_hour Time zone offset hour portion 0 timezone_minute Time zone offset minute portion 0 timezone Time zone offset in second... - https://man.mtool.work/duckdb/2.0/sql/functions/datepart.html
- ICU Extension 15707
- 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 zone
...e data built directly from the IANA Time Zone Database . Behavior is unchanged, and the native implementation is smaller and faster. If you ship a custom build, no...ally, run: INSTALL AND LOAD icu; Features The icu extension introduces the following features: Region-dependent collations Time zones , used for timestamp data types and timestamp functions... - https://man.mtool.work/duckdb/2.0/core_extensions/icu.html
- Data Types 14563
- 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
...EOMETRY data type HUGEINT Signed sixteen-byte integer INTEGER INT4 , INT , SIGNED Signed four-byte integer INTERVAL Date / time delta JSON JSON object (via the json extension ) SMALLINT INT2 , SHORT Signed two-byte integer TIME Time of day (no time z...one) TIMESTAMP WITH TIME ZONE TIMESTAMPTZ Combination of time and date that uses the current time zone TIMESTAMP DATETIME Combinatio... - https://man.mtool.work/duckdb/2.0/sql/data_types/overview.html
- Typecasting 14164
- Typecasting is an operation that converts a value in one particular data type to the closest corresponding value in another data type. Like other SQL engines, DuckDB supports both implicit and explicit typecasting. Explicit Casting Explicit
..., list_value(1::INT64, 1::UINT64) creates a list of type INT128[] . The implicit casts performed in this situation are sometimes more lenient than regular implicit casts. For example, a BOOL value may be cast to INT (with true mapping to 1 and false...citly (with CAST or :: ); an empty cell marks an unsupported cast. Even where a cast is supported, it may still fail at runtime for a particular value (for example, out of range or unparseable input). Column abbreviations: BOOL (BOOLEAN), I8 (TINYINT...), STR (VARCHAR), BLOB (BLOB), BIT (BIT), UUID (UUID), DATE (DATE), TIME (TIME), TS (TIMESTAMP), TSTZ (TIMESTAMP WITH TIME ZONE), TTZ (TIME WITH TIME ZONE), IVL (INTERVAL). From \ To BOOL I8 I16 I32 I64 I128 U8 U16 U32 U64 U128 F32 F64 DEC STR BLOB B... - https://man.mtool.work/duckdb/2.0/sql/data_types/typecasting.html
DuckDB 2.0 Documentation / man.mtool.work