Results of 1 - 10 of about 370 for Current (0.005 sec.)
- Timestamp with Time Zone Functions – DuckDB 11973
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...the related TIMESTAMP functions . Time zone support is provided by the built-in ICU extension . In the examples below, the current time zone is presumed to be America/Los_Angeles using the Gregorian calendar. Built-In Timestamp with Time Zone Functions...r TIMESTAMPTZ values. Since these functions do not involve binning or display, they are always available. Name Description current_timestamp Current date and time (start of current transaction). get_current_timestamp() Current date and time (start of cu...imestamp with time zone is infinite, false otherwise. least(timestamptz, timestamptz) The earlier of two timestamps. now() Current date and time (start of current transaction). timetz_byte_comparable(timetz) Converts a TIME WITH TIME ZONE to a UBIGINT s... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamptz.html
- Window Functions – DuckDB 11735
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...y region : SELECT row_number () OVER ( PARTITION BY region ORDER BY time ) FROM sales ; Compute the difference between the current and the previous-by- time amount : SELECT amount - lag ( amount ) OVER ( ORDER BY time ) FROM sales ; Compute the percenta...e Description cume_dist([ORDER BY ordering]) The cumulative distribution: (number of partition rows preceding or peer with current row) / total partition rows. dense_rank() The rank of the current row without gaps; this function counts peer groups. firs...expr evaluated at the row that is offset rows (among rows with a non-null value of expr if IGNORE NULLS is set) before the current row within the window frame; if there is no such row, instead return default (which must be of the Same type as expr ). Bo... - https://man.mtool.work/duckdb/1.3/sql/functions/window_functions.html
- Utility Functions – DuckDB 11612
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...te_sort_key(parameters...) Constructs a binary-comparable sort key based on a set of input parameters and sort qualifiers. current_catalog() Return the name of the currently active catalog. Default is memory. current_database() Return the name of the cu...rrently active database. current_query() Return the current query as a string. current_schema() Return the name of the currently active schema. Default is...main. current_schemas(boolean) Return list of schemas. Pass a parameter of true to include implicit schemas. current_setting('setting_na... - https://man.mtool.work/duckdb/1.3/sql/functions/utility.html
- Time Functions – DuckDB 10775
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ERVAL 5 HOUR 01:02:03 Time Functions The table below shows the available scalar functions for TIME types. Name Description current_time Current time (start of current transaction) in the local time zone. Note that parentheses should be omitted from the...as of date_sub. The number of complete partitions between the times. extract(part FROM time) Get subfield from a time. get_current_time() Current time (start of current transaction) in UTC. make_time(bigint, bigint, double) The time for the given parts....The only date parts that are defined for times are epoch , hours , minutes , seconds , milliseconds and microseconds . current_time Description Current time (start of current transaction) in the local time zone. Note that parentheses should be omitt... - https://man.mtool.work/duckdb/1.3/sql/functions/time.html
- Information Schema – DuckDB 8969
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...greSQL's information schema . Tables character_sets : Character Sets Column Description Type Example character_set_catalog Currently not implemented – always NULL . VARCHAR NULL character_set_schema Currently not implemented – always NULL . VARCHAR NULL...character_set_name Name of the character set, currently implemented as showing the name of the database encoding. VARCHAR 'UTF8' character_repertoire Character repertoire, show...atabase encoding. VARCHAR 'UTF8' default_collate_catalog Name of the database containing the default collation (always the current database). VARCHAR 'my_db' default_collate_schema Name of the schema containing the default collation. VARCHAR 'pg_catalog... - https://man.mtool.work/duckdb/1.3/sql/meta/information_schema.html
- Enum Data Type – DuckDB 8370
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...can create a table with a column that references the enum. Creates a table person , with attributes name (string type) and current_mood (mood type): CREATE TABLE person ( name TEXT , current_mood mood ); Inserts tuples in the person table: INSERT INTO p...ference value. This makes the comparison a numerical comparison instead of a string comparison. SELECT * FROM person WHERE current_mood = 'sad' ; name current_mood Pagliacci sad If you are importing data from a file, you can create an enum for a VARCHAR...en you can create a table with the enum type and import using any data import statement: CREATE TABLE person ( name TEXT , current_mood mood ); COPY person FROM 'path/to/file.csv' ; Enums vs. Strings DuckDB enums are automatically cast to VARCHAR types... - https://man.mtool.work/duckdb/1.3/sql/data_types/enum.html
- Date Functions – DuckDB 7524
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ctions for DATE types. Dates can also be manipulated with the timestamp functions through type promotion. Name Description current_date Current date (at start of current transaction) in the local time zone. Note that parentheses should be omitted from t...1-01 when bucket_width is a number of months or coarser units, else 2000-01-03 . Note that 2000-01-03 is a Monday. today() Current date (start of current transaction) in UTC. current_date Description Current date (at start of current transaction) in the...local time zone. Note that parentheses should be omitted from the function call. Example current_date Result 2022-10-08 date_add(date, interval) Description Add the interval to the date and return a DATETIME value. Exam... - https://man.mtool.work/duckdb/1.3/sql/functions/date.html
- Editing – DuckDB 6801
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...n Format Pivot Sitemap Live Demo Documentation / Client APIs / CLI Copy Markdown Editing The linenoise-based CLI editor is currently only available for macOS and Linux. DuckDB's CLI uses a line-editing library based on linenoise , which has shortcuts th...buffer is empty, end editing Ctrl + H Delete previous character Ctrl + K Delete everything after the cursor Ctrl + T Swap current and next character Ctrl + U Delete all text Ctrl + W Delete previous word Alt + C Convert next word to titlecase Alt + D D...elete next word Alt + L Convert next word to lowercase Alt + R Delete all text Alt + T Swap current and next word Alt + U Convert next word to uppercase Alt + Backspace Delete previous word Alt + \ Delete spaces around cur... - https://man.mtool.work/duckdb/1.3/clients/cli/editing.html
- Multiple Python Threads – DuckDB 6687
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...insert the timestamp when that insert occurred using the DEFAULT expression . import duckdb from threading import Thread , current_thread import random duckdb_con = duckdb . connect ( 'my_peristent_db.duckdb' ) # Use connect without parameters for an in...nnect() duckdb_con . execute ( """ CREATE OR REPLACE TABLE my_inserts ( thread_name VARCHAR, insert_time TIMESTAMP DEFAULT current_timestamp ) """ ) Reader and Writer Functions Next, define functions to be executed by the writer and reader threads. Each...on = duckdb_con . cursor () # Insert a row with the name of the thread. insert_time is auto-generated. thread_name = str ( current_thread (). name ) result = local_con . execute ( """ INSERT INTO my_inserts (thread_name) VALUES (?) """ , ( thread_name ,... - https://man.mtool.work/duckdb/1.3/guides/python/multiple_threads.html
- Timestamp Functions – DuckDB 5964
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
..., timestamp) Subtract arguments, resulting in the time difference between the two timestamps. age(timestamp) Subtract from current_date. century(timestamp) Extracts the century of a timestamp. current_localtimestamp() Returns the current timestamp (at t...e(TIMESTAMP '2001-04-10', TIMESTAMP '1992-09-20') Result 8 years 6 months 20 days age(timestamp) Description Subtract from current_date. Example age(TIMESTAMP '1992-09-20') Result 29 years 1 month 27 days 12:39:00.844 century(timestamp) Description Extr...acts the century of a timestamp. Example century(TIMESTAMP '1992-03-22') Result 20 current_localtimestamp() Description Returns the current timestamp with time zone (at the start of the transaction). Example curre... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamp.html
DuckDB 1.3 Documentation / man.mtool.work