Results of 1 - 10 of about 35 for Zone (0.004 sec.)
- Timestamp Types 12889
- 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
...ame 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 times...tamp 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...w The TIMESTAMPTZ_NS type was introduced in DuckDB 2.0. It provides time zone aware timestamps with nanosecond precision. External columns with nanosecond precision and WITH TIME ZONE semantics, e.g.,... - https://man.mtool.work/duckdb/2.0/sql/data_types/timestamp.html
- Timestamp with Time Zone Functions 12205
- 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...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....amps. now() Current date and time (start of current transaction). 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_ti... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamptz.html
- Timestamp Issues 11298
- 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
...PTZ, 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 change to another time z...one, the results of the query change: SET timezone = 'HST'; FROM times WHERE t <= '2025-08-30'; ┌──────────────────────────┐ │ t │ │ timestamp with time zone │ ├────────────...5-08-29 22:00:00-10 │ │ 2025-08-29 23:00:00-10 │ │ 2025-08-30 00:00:00-10 │ └──────────────────────────┘ Or worse: SET timezone = 'America/New_York'; FROM times WHERE t <= '2025-08-30'; ┌──────────────────────────┐ │ t │ │ timestamp with time zone │... - https://man.mtool.work/duckdb/2.0/guides/sql_features/timestamps.html
- S3 Express One 10534
- In late 2023, AWS announced the S3 Express One Zone , a high-speed variant of traditional S3 buckets. DuckDB can read S3 Express One buckets using the httpfs extension . Credentials and Configuration The configuration of S3 Express One buck
...r S3 buckets with one exception: you must specify the endpoint according to the following pattern: s3express-⟨availability_zone⟩.⟨region⟩.amazonaws.com where the ⟨availability_zone⟩ (e.g., use-az5 ) can be obtained from the S3 Express One bucket's co....⟨us-east-1⟩.amazonaws.com' ); Instance Location For best performance, ensure the EC2 instance is in the same availability zone as the S3 Express One bucket you are querying. To determine the mapping between zone names and zone IDs, use the aws ec2 d...escribe-availability-zones command. Zone name to zone ID mapping: bash aws ec2 describe-availability-zones --output json \ | jq -r '.AvailabilityZon... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/s3_express_one.ht...
- DuckLake 10327
- 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
...d │ snapshot_time │ schema_version │ changes │ author │ commit_message │ commit_extra_info │ │ int64 │ timestamp with time zone │ int64 │ map(varchar, varchar[]) │ varchar │ varchar │ varchar │ ├─────────────┼────────────────────────────┼────────────...coded 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 commit_extra_info VARCHAR duck...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
- Date Part Functions 9961
- 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
...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...s 0 week Week number weeks , w 31 yearweek ISO year and week number in YYYYWW format 202131 Note that the time zone parts are all zero unless a time zone extension such as ICU has been installed to support TIMESTAMP WITH TIME ZONE . Part...d(date) Sub-minute milliseconds. minute(date) Minutes. month(date) Month. quarter(date) Quarter. second(date) Seconds. timezone_hour(date) Time zone offset hour portion. timezone_minute(date) Time zone offset minutes portion. timezone(date) Time zone... - https://man.mtool.work/duckdb/2.0/sql/functions/datepart.html
- ICU Extension 8481
- 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, note th...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
- Time Functions 8449
- 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
...nctions 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...conds and microseconds . current_localtime() | Description | Current time (start of current transaction) in the local time zone, as a TIME value without a time zone. | | Example | current_localtime() | | Result | 06:09:59.988 | | Alias | localtime (n...21:13') | | Result | 14 | get_current_time() | Description | Current time (start of current transaction) in the local time zone as TIMETZ . | | Example | get_current_time() | | Result | 06:09:59.988+2 | | Alias | current_time (no parentheses necessar... - https://man.mtool.work/duckdb/2.0/sql/functions/time.html
- Time Types 8195
- 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
... - https://man.mtool.work/duckdb/2.0/sql/data_types/time.html
- SET and RESET Statements 7654
- The SET statement modifies the provided DuckDB configuration option at the specified scope. Examples Update the memory_limit configuration value: SET memory_limit = '10GB'; Configure the system to use 1 thread: SET threads = 1; Or use the T
...nstance is started, configuration options use their defaults unless they are set again. For example, in DuckDB 2.0 the TimeZone option defaults to the SESSION scope, so the following two statements are equivalent, and both change the time zone for th...e current session only: SET TimeZone = 'UTC'; SET SESSION TimeZone = 'UTC'; To change the time zone for every session connected to the instance, use the GLOBAL...scope explicitly: SET GLOBAL TimeZone = 'UTC'; Configuration See the Configuration page for the full list of configuration options.... - https://man.mtool.work/duckdb/2.0/sql/statements/set.html
DuckDB 2.0 Documentation / man.mtool.work