Results of 1 - 6 of about 6 for effectively (0.002 sec.)
- Timestamp with Time Zone Functions 12813
- 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
...operate on plain TIMESTAMP values. These functions assume that the TIMESTAMP is a “local timestamp”. A local timestamp is effectively a way of encoding the part values from a time zone into a single value. They should be used with caution because the produ...all. timezone(text, timestamp) Use the date parts of the timestamp in GMT to construct a timestamp in the given time zone. Effectively, the argument is a “local” time. timezone(text, timestamptz) Use the date parts of the timestamp in the given time zone to...construct a timestamp. Effectively, the result is a “local” time. current_localtime() | Description | Returns a TIME whose GMT bin values correspond to local... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamptz.html
- CASE Expression 9194
- The CASE expression performs a switch based on a condition. The basic form is identical to the ternary condition used in many programming languages ( CASE WHEN cond THEN a ELSE b END is equivalent to cond ? a : b ). With a single condition
...ossible to provide an individual expression after the CASE but before the WHEN . When this is done, the CASE expression is effectively transformed into a switch statement. CREATE OR REPLACE TABLE integers AS SELECT unnest([1, 2, 3]) AS i; SELECT i, CASE i W... - https://man.mtool.work/duckdb/2.0/sql/expressions/case.html
- CREATE MACRO Statement 9194
- The CREATE MACRO statement defines a named, callable SQL expression as a database schema object. Macros may declare parameters, which can be referenced by its expression. Once a macro is created, it may be called by referencing its name and
...default and use conditional logic in the expression to produce the run-time value). Specifying a default value expression effectively makes the parameter optional: when the macro is called, the DuckDb binder will find candidate signatures based on passed p...ut allow = as assignment operator. For macros, this won't work! Instead, the = is interpreted as comparison operator. This effectively turns the - intended - named parameter into a positional parameter passing the result of comparing the parameter name with... - https://man.mtool.work/duckdb/2.0/sql/statements/create_macro.html
- ODBC Extension Functions 8828
- odbc_begin_transaction odbc_bind_params odbc_close odbc_commit odbc_connect odbc_copy odbc_create_params odbc_list_data_sources odbc_list_drivers odbc_query odbc_rollback odbc_begin_transaction odbc_begin_transaction(conn_handle BIGINT) ->
...VARCHAR Sets the SQL_ATTR_AUTOCOMMIT attribute to SQL_AUTOCOMMIT_OFF on the specified connection thus effectively starting an implicit transaction. odbc_commit or odbc_rollback must be called on such connection to complete the transacti...E ): whether to create a table in the destination remote DB using the column names and column types from the source query, effectively implements CTAS (create table as select) column_types ( MAP(VARCHAR, VARCHAR) ): when create_table=TRUE is specified, allo... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/functions.html
- Unnesting 7750
- Unnesting is an operation that decomposes values of a composite types into its components. Values of the LIST and STRUCT type may be unnested using the unnest() function . Unnesting turns a LIST -typed value into a table column: each list-e
...ssing false , recursion is disabled. In that case, other additional parameters such as max_depth and keep_parent_names are effectively ignored max_depth : UINT32 , default: 1 . This controls how many levels of recursion should at most be applied. Values gre... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/unnest.html
- Connect 7019
- Overview Every DuckDB feature reachable from Java starts with a Connection . This page covers the JDBC URL forms the driver accepts, how DuckDB and driver options are passed and which of them win, how connections come to share (or not share
...plain jdbc:duckdb: URL — which no other URL can address. On a named in-memory or a file-backed connection, duplicate() is effectively the same as opening a new connection on the same URL, because those instances are shared through the instance cache anyway... - https://man.mtool.work/duckdb/2.0/clients/java/connecting.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work