Results of 1 - 10 of about 28 for according (0.002 sec.)
- Timestamp Functions 13256
- 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
...timestamp. monthname(timestamp) The (English) name of the month. strftime(timestamp, format) Converts timestamp to string according to the format string . strptime(text, format-list) Converts the string text to timestamp applying the format strings in th...ror on failure. To return NULL on failure, use try_strptime . strptime(text, format) Converts the string text to timestamp according to the format string . Throws an error on failure. To return NULL on failure, use try_strptime . time_bucket(bucket_width,...in the list until one succeeds. Returns NULL on failure. try_strptime(text, format) Converts the string text to timestamp according to the format string . Returns NULL on failure. There are also dedicated extraction functions to get the subfields . Funct... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamp.html
- IN Operator 11470
- The IN operator checks containment of the left expression inside the collection on the right hand side (RHS). Supported collections on the RHS are tuples, lists, and maps, as well as subqueries that return a single column. The single-column
...th', NULL); true SELECT 'English' IN ('CS', 'Math', NULL); NULL IN [val1, val2, ...] (List) The IN operator works on lists according to the semantics used in Python. Unlike for the IN tuple operator , the presence of NULL values on the right hand side of...'Math' IN ['CS', 'Math', NULL]; true SELECT 'English' IN ['CS', 'Math', NULL]; false IN Map The IN operator works on maps according to the semantics used in Python, i.e., it checks for the presence of keys (not values): SELECT 'key1' IN MAP {'key1': 50,... - https://man.mtool.work/duckdb/2.0/sql/expressions/in.html
- Date Format Functions 11470
- The strftime and strptime functions can be used to convert between DATE / TIMESTAMP values and strings. This is often required when parsing CSV files, displaying output to the user or transferring information between programs. Because there
...timestamp should be structured. strftime Examples The strftime(timestamp, format) converts timestamps or dates to strings according to the specified pattern. SELECT strftime(DATE '1992-03-02', '%d/%m/%Y'); 02/03/1992 SELECT strftime(TIMESTAMP '1992-03-02...); Monday, 2 March 1992 - 08:32:45 PM strptime Examples The strptime(text, format) function converts strings to timestamps according to the specified pattern. SELECT strptime('02/03/1992', '%d/%m/%Y'); 1992-03-02 00:00:00 SELECT strptime('Monday, 2 March...error on failure: SELECT strptime('02/50/1992', '%d/%m/%Y') AS x; Invalid Input Error: Could not parse string "02/50/1992" according to format specifier "%d/%m/%Y" 02/50/1992 ^ Error: Month out of range, expected a value between 1 and 12 To return NULL on... - https://man.mtool.work/duckdb/2.0/sql/functions/dateformat.html
- Timestamp with Time Zone Functions 9979
- 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 ZONE for the given µs since the epoch. strftime(timestamptz, format) Converts a TIMESTAMP WITH TIME ZONE value to string according to the format string . strptime(text, format) Converts string to TIMESTAMP WITH TIME ZONE according to the format string i...-07 00:43:04.123456-08 | strftime(timestamptz, format) | Description | Converts a TIMESTAMP WITH TIME ZONE value to string according to the format string . | | Example | strftime(timestamptz '1992-01-01 20:38:40', '%a, %-d %B %Y - %I:%M:%S %p') | | Result...| Wed, 1 January 1992 - 08:38:40 PM | strptime(text, format) | Description | Converts string to TIMESTAMP WITH TIME ZONE according to the format string if %Z is specified. | | Example | strptime('Wed, 1 January 1992 - 08:38:40 PST', '%a, %-d %B %Y - %H:... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamptz.html
- ODBC API Overview 9389
- Installation To use the DuckDB ODBC client, visit the ODBC installation page . The latest stable version of the DuckDB ODBC client is 2.0.0. This page describes the DuckDB ODBC driver, which lets other applications connect to DuckDB . To co
...hat performs the specified function and returns the proper values. DuckDB ODBC Driver DuckDB supports the ODBC version 3.0 according to the Core Interface Conformance . The ODBC driver is available for all operating systems. Visit the installation page fo... - https://man.mtool.work/duckdb/2.0/clients/odbc/overview.html
- Date Types 9389
- 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 ( YYYY-MM-DD ). SELECT DATE '1992-09-20'; Special Values There are also three special date values t... - https://man.mtool.work/duckdb/2.0/sql/data_types/date.html
- Time Types 9094
- 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
...precision Instances can be created using the type names as 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 SE... - https://man.mtool.work/duckdb/2.0/sql/data_types/time.html
- Date Functions 8799
- 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 for the given parts. monthname(date) The (English) name of the month. strftime(date, format) Converts a date to a string according to the format string . time_bucket(bucket_width, date[, offset]) Truncate date to a grid of width bucket_width . The grid...| monthname(DATE '1992-09-20') | | Result | September | strftime(date, format) | Description | Converts a date to a string according to the format string . | | Example | strftime(DATE '1992-01-01', '%a, %-d %B %Y') | | Result | Wed, 1 January 1992 | time_... - https://man.mtool.work/duckdb/2.0/sql/functions/date.html
- Concurrency 8488
- Handling Concurrency Single Process In in-process mode, DuckDB has two configurable options for concurrency: Read-write mode: one process can both read and write to the database. Read-only mode: multiple processes can read from the database
...same connection are faster. Concurrency Model within a Single Process DuckDB supports concurrency within a single process according to the following rules. As long as there are no write conflicts, multiple concurrent writes will succeed. Appends will nev... - https://man.mtool.work/duckdb/2.0/connect/concurrency.html
- S3 Express One 8488
- 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
...ets is similar to regular 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-az... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/s3_express_one.ht...
DuckDB 2.0 Documentation / man.mtool.work