Results of 1 - 4 of about 4 for synonym (0.001 sec.)
- Date Part Functions 12297
- 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
...re returned for infinite timestamps. Part Specifiers Usable as Date Part Specifiers and in Intervals Specifier Description Synonyms Example century Gregorian century cent , centuries , c 21 day Gregorian day days , d , dayofmonth 3 decade Gregorian deca...44 year Gregorian year yr , y , years , yrs 2021 Part Specifiers Only Usable as Date Part Specifiers Specifier Description Synonyms Example dayofweek Day of the week (Sunday = 0, Saturday = 6) weekday , dow 2 dayofyear Day of the year (1-365/366) doy 21...xtraction functions to get certain subfields: Name Description century(date) Century. day(date) Day. dayofmonth(date) Day (synonym). dayofweek(date) Numeric weekday (Sunday = 0, Saturday = 6). dayofyear(date) Day of the year (starts from 1, i.e., Januar... - https://man.mtool.work/duckdb/2.0/sql/functions/datepart.html
- Timestamp with Time Zone Functions 9116
- 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
...timestamp() Returns a TIMESTAMP whose GMT bin values correspond to local date and time in the current time zone. localtime Synonym for the current_localtime() function call. localtimestamp Synonym for the current_localtimestamp() function call. timezone...current time zone. | | Example | current_localtimestamp() | | Result | 2022-12-17 08:47:56.497 | localtime | Description | Synonym for the current_localtime() function call. | | Example | localtime | | Result | 08:47:56.497 | localtimestamp | Descriptio...n | Synonym for the current_localtimestamp() function call. | | Example | localtimestamp | | Result | 2022-12-17 08:47:56.497 | timezo... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamptz.html
- Map Type 7933
- MAP s are similar to STRUCT s in that they are an ordered list of key-value pairs. However, MAP s do not need to have the same keys present for each row, and thus are suitable for use cases where the schema is unknown beforehand or varies p
...d in the map, a NULL value is returned: SELECT MAP {'key1': 5, 'key2': 43}['key3']; NULL The map_extract function (and its synonym element_at ) can be used to retrieve a value wrapped in a list; it returns an empty list if the key is not contained in th... - https://man.mtool.work/duckdb/2.0/sql/data_types/map.html
- Star Expression 7600
- Syntax The * expression can be used in a SELECT statement to select all columns that are projected in the FROM clause. SELECT * FROM tbl; TABLE.* and STRUCT.* The * expression can be prepended by a table name to select only columns from tha
...ude specific columns from the * expression. SELECT * EXCLUDE (col) FROM tbl; New As of DuckDB 2.0, EXCEPT is accepted as a synonym for EXCLUDE , matching the SQL-standard and BigQuery spelling. The two keywords are interchangeable and may be mixed in th... - https://man.mtool.work/duckdb/2.0/sql/expressions/star.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work