Results of 1 - 10 of about 128 for Number (0.005 sec.)
- Date Format Functions – DuckDB 11415
- 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
...entation 1992-03-02 10:30:20 %d Day of the month as a zero-padded decimal. 01, 02, …, 31 %-d Day of the month as a decimal number. 1, 2, …, 30 %f Microsecond as a decimal number, zero-padded on the left. 000000 - 999999 %g Millisecond as a decimal numb...part of the ISO week (see %V ). 0001, 0002, …, 2013, 2014, …, 9998, 9999 %H Hour (24-hour clock) as a zero-padded decimal number. 00, 01, …, 23 %-H Hour (24-hour clock) as a decimal number. 0, 1, …, 23 %I Hour (12-hour clock) as a zero-padded decimal...number. 01, 02, …, 12 %-I Hour (12-hour clock) as a decimal number. 1, 2, … 12 %j Day of the year as a zero-padded decimal number. 001, 002, …, 366 %-j Day of the year as a decimal number.... - https://man.mtool.work/duckdb/1.3/sql/functions/dateformat.html
- Text Functions – DuckDB 10658
- 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
...) Converts a blob to a base64 encoded string. bin(string) Converts the string to binary representation. bit_length(string) Number of bits in a string . char_length(string) Number of characters in string . character_length(string) Number of characters i...s the left-most count characters. left_grapheme(string, count) Extracts the left-most count grapheme clusters. len(string) Number of characters in string . length(string) Number of characters in string . length_grapheme(string) Number of grapheme clust...left side of the string . characters defaults to space . md5(string) Returns the MD5 hash of the string as a VARCHAR . md5_number(string) Returns the MD5 hash of the string as a HUGEINT . md5_number_lower(string) Returns the lower 64-bit segment of the... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Window Functions – DuckDB 10365
- 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
...ndow function are available in SQL since SQL:2003 and are supported by major SQL database systems. Examples Generate a row_number column to enumerate rows: SELECT row_number () OVER () FROM sales ; Tip If you only need a number for each row in a table,...you can use the rowid pseudocolumn . Generate a row_number column to enumerate rows, ordered by time : SELECT row_number () OVER ( ORDER BY time ) FROM sales ; Generate a row_number...column to enumerate rows, ordered by time and partitioned by region : SELECT row_number () OVER ( PARTITION BY region ORDER BY time ) FROM sales ; Compute the difference between the current and the previous-by-... - https://man.mtool.work/duckdb/1.3/sql/functions/window_functions.html
- Node.js API – DuckDB 9803
- This page is for DuckDB 1.3, which is outdated. Switch to the current documentation . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Ove
...unregister_udf(name) ⇒ this .registerReplacementScan(fun) ⇒ this .tokenize(text) ⇒ ScriptTokens .get() ~TokenType ~ERROR : number ~OPEN_READONLY : number ~OPEN_READWRITE : number ~OPEN_CREATE : number ~OPEN_FULLMUTEX : number ~OPEN_SHAREDCACHE : number...~OPEN_PRIVATECACHE : number duckdb~Connection Kind : inner class of duckdb ~Connection .run(sql, …params, callback) ⇒ void .all(sql, …params, callback...ce method of Database duckdb~TokenType Types of tokens return by tokenize . Kind : inner property of duckdb duckdb~ERROR : number Check that errno attribute equals this to check for a duckdb error Kind : inner constant of duckdb duckdb~OPEN_READONLY :... - https://man.mtool.work/duckdb/1.3/clients/nodejs/reference.html
- Numeric Functions – DuckDB 9461
- 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
...mputes the inverse hyperbolic tangent of x . atan2(y, x) Computes the inverse tangent of (y, x) . bit_count(x) Returns the number of bits that are set. cbrt(x) Returns the cube root of the number. ceil(x) Rounds the number up. ceiling(x) Rounds the num...es the cotangent of x . degrees(x) Converts radians to degrees. divide(x, y) Alias for x // y . even(x) Round to next even number by rounding away from zero. exp(x) Computes e ** x . factorial(x) See the ! operator. Computes the product of the current...and all integers below it. fdiv(x, y) Performs integer division ( x // y ) but returns a DOUBLE value. floor(x) Rounds the number down. fmod(x, y) Calculates the modulo value. Always returns a DOUBLE value. gamma(x) Interpolation of the factorial of x... - https://man.mtool.work/duckdb/1.3/sql/functions/numeric.html
- Timestamp Functions – DuckDB 9461
- 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
..._localtimestamp() Returns the current timestamp (at the start of the transaction). date_diff(part, startdate, enddate) The number of partition boundaries between the timestamps. date_part([part, ...], timestamp) Get the listed subfields as a struct . T...must be constant. date_part(part, timestamp) Get subfield (equivalent to extract ). date_sub(part, startdate, enddate) The number of complete partitions between the timestamps. date_trunc(part, timestamp) Truncate to specified precision . datediff(part..., startdate, enddate) Alias of date_diff . The number of partition boundaries between the timestamps. datepart([part, ...], timestamp) Alias of date_part . Get the listed subfi... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamp.html
- Date Functions – DuckDB 8448
- 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
...date_add(date, interval) Add the interval to the date and return a DATETIME value. date_diff(part, startdate, enddate) The number of partition boundaries between the dates. date_part(part, date) Get the subfield (equivalent to extract ). date_sub(part,...startdate, enddate) The number of complete partitions between the dates. date_trunc(part, date) Truncate to specified precision . datediff(part, startdat...e, enddate) The number of partition boundaries between the dates. Alias of date_diff . datepart(part, date) Get the subfield (equivalent to extra... - https://man.mtool.work/duckdb/1.3/sql/functions/date.html
- Star Expression – DuckDB 8350
- 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
...regular star expression, but additionally allows you to execute the same expression on the resulting columns. CREATE TABLE numbers ( id INTEGER , number INTEGER ); INSERT INTO numbers VALUES ( 1 , 10 ), ( 2 , 20 ), ( 3 , NULL ); SELECT min ( COLUMNS (...* )), count ( COLUMNS ( * )) FROM numbers ; id number id number 1 10 3 2 SELECT min ( COLUMNS ( * REPLACE ( number + id AS number ))), count ( COLUMNS ( * EXCLUDE...( number ))) FROM numbers ; id min(number := (number + id)) id 1 11 3 COLUMNS expressions can also be combined, as long as they con... - https://man.mtool.work/duckdb/1.3/sql/expressions/star.html
- DuckDB_% Metadata Functions – DuckDB 7948
- 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
...uckDB text types do not enforce a value length restriction based on a length type parameter. INTEGER numeric_precision The number of units (in the base indicated by numeric_precision_radix ) used for storing column values. For integral and approximate...numeric types, this is the number of bits. For decimal types, this is the number of digits positions. INTEGER numeric_precision_radix The number-base of the...meric_precision column. For integral and approximate numeric types, this is 2 , indicating the precision is expressed as a number of bits. For the decimal type this is 10 , indicating the precision is expressed as a number of decimal positions. INTEGER... - https://man.mtool.work/duckdb/1.3/sql/meta/duckdb_table_functions.html
- Time Functions – DuckDB 7655
- 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
...e local time zone. Note that parentheses should be omitted from the function call. date_diff(part, starttime, endtime) The number of partition boundaries between the times. date_part(part, time) Get subfield (equivalent to extract ). date_sub(part, sta...rttime, endtime) The number of complete partitions between the times. datediff(part, starttime, endtime) Alias of date_diff . The number of partition...time) Alias of date_part. Get subfield (equivalent to extract ). datesub(part, starttime, endtime) Alias of date_sub. The number of complete partitions between the times. extract(part FROM time) Get subfield from a time. get_current_time() Current tim... - https://man.mtool.work/duckdb/1.3/sql/functions/time.html
DuckDB 1.3 Documentation / man.mtool.work