Results of 1 - 6 of about 6 for America (0.002 sec.)
- Time Zone Reference List 13215
- An up-to-date version of this list can be pulled from the pg_timezone_names() table function: SELECT name, abbrev FROM pg_timezone_names() ORDER BY name; name abbrev ACT ACT AET AET AGT AGT ART ART AST AST Africa/Abidjan Iceland Africa/Accr
...ome Africa/Sao_Tome Africa/Timbuktu Iceland Africa/Tripoli Libya Africa/Tunis Africa/Tunis Africa/Windhoek Africa/Windhoek America/Adak America/Adak America/Anchorage AST America/Anguilla PRT America/Antigua PRT America/Araguaina America/Araguaina Ameri...ca/Argentina/Buenos_Aires AGT America/Argentina/Catamarca America/Argentina/Catamarca America/Argentina/ComodRivadavia America/Argentina/ComodRivadavia America/...Argentina/Cordoba America/Argentina/Cordoba America/Argentina/Jujuy America/Argentina/Jujuy America/Argentina/La_Rioja America/Argentina/La_Rioja Am... - https://man.mtool.work/duckdb/2.0/sql/data_types/timezones.html
- Timestamp Types 8536
- 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
...e zone. To use an alternative time zone, the timezone function provided by the ICU extension may be used: SELECT timezone('America/Denver', TIMESTAMP '2001-02-16 20:38:40') AS aware1, timezone('America/Denver', TIMESTAMPTZ '2001-02-16 04:38:40') AS naiv...re displayed with the UTC offset of the configured time zone, which is 'Europe/Berlin' in the example. The UTC offsets of 'America/Denver' and 'Europe/Berlin' at all involved instants are -07:00 and +01:00 , respectively. Special Values Three special st...orian calendar, but time zones apply locale-specific rules and can vary widely. For example, here is what binning for the 'America/Los_Angeles' time zone looks like near the epoch: The most common temporal binning problem occurs when daylight saving tim... - https://man.mtool.work/duckdb/2.0/sql/data_types/timestamp.html
- Timestamp with Time Zone Functions 8353
- 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...GMT to construct a timestamp in the given time zone. Effectively, the argument is a “local” time. | | Example | timezone('America/Denver', TIMESTAMP '2001-02-16 20:38:40') | | Result | 2001-02-16 19:38:40-08 | timezone(text, timestamptz) | Description...estamp in the given time zone to construct a timestamp. Effectively, the result is a “local” time. | | Example | timezone('America/Denver', TIMESTAMPTZ '2001-02-16 20:38:40-05') | | Result | 2001-02-16 18:38:40 | At Time Zone The AT TIME ZONE syntax is... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamptz.html
- Timestamp Issues 8298
- 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
...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
- Directly Read DuckDB Databases 8189
- DuckDB allows directly reading DuckDB files through the read_duckdb function: read_duckdb(⟨'path_to_database'⟩, table_name = ⟨'table_to_read'⟩); Using this function is equivalent to performing the following steps: Attaching to the database
...───────────┬─────────────┐ │ r_regionkey │ r_name │ │ int32 │ varchar │ ├─────────────┼─────────────┤ │ 0 │ AFRICA │ │ 1 │ AMERICA │ │ 2 │ ASIA │ │ 3 │ EUROPE │ │ 4 │ MIDDLE EAST │ └─────────────┴─────────────┘ Reading from Multiple Databases You can us... - https://man.mtool.work/duckdb/2.0/guides/file_formats/read_duckdb.html
- Date Part Functions 8189
- 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
...d for DATE values. | | Example | timezone_hour(TIMESTAMPTZ '1992-02-15 01:00:00+00') | | Result | -5 (with TimeZone set to America/New_York ) | timezone_minute(date) | Description | Time zone offset minutes portion. Only meaningful for TIMESTAMP WITH TI...ed for DATE values. | | Example | timezone(TIMESTAMPTZ '1992-02-15 01:00:00+00') | | Result | -18000 (with TimeZone set to America/New_York ) | week(date) | Description | ISO Week. | | Example | week(DATE '1992-02-15') | | Result | 7 | weekday(date) | D... - https://man.mtool.work/duckdb/2.0/sql/functions/datepart.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work