# DuckDB 1.5.5 function index

> 904 function names observed in v1.5.5, source ID d8cdaa33fd.

For accepted argument and return types, fetch the [structured index](/products/haybarn/functions/api/v1/duckdb-1.5.5/functions.json).

## Functions

- [__internal_compress_integral_ubigint](/products/haybarn/functions/releases/duckdb-1.5.5/operator-5f5f696e7465726e616c5f636f6d70726573735f696e74656772616c5f75626967696e74/index.md): No description supplied.
- [__internal_compress_integral_uinteger](/products/haybarn/functions/releases/duckdb-1.5.5/operator-5f5f696e7465726e616c5f636f6d70726573735f696e74656772616c5f75696e7465676572/index.md): No description supplied.
- [__internal_compress_integral_usmallint](/products/haybarn/functions/releases/duckdb-1.5.5/operator-5f5f696e7465726e616c5f636f6d70726573735f696e74656772616c5f75736d616c6c696e74/index.md): No description supplied.
- [__internal_compress_integral_utinyint](/products/haybarn/functions/releases/duckdb-1.5.5/operator-5f5f696e7465726e616c5f636f6d70726573735f696e74656772616c5f7574696e79696e74/index.md): No description supplied.
- [__internal_compress_string_hugeint](/products/haybarn/functions/releases/duckdb-1.5.5/operator-5f5f696e7465726e616c5f636f6d70726573735f737472696e675f68756765696e74/index.md): No description supplied.
- [__internal_compress_string_ubigint](/products/haybarn/functions/releases/duckdb-1.5.5/operator-5f5f696e7465726e616c5f636f6d70726573735f737472696e675f75626967696e74/index.md): No description supplied.
- [__internal_compress_string_uhugeint](/products/haybarn/functions/releases/duckdb-1.5.5/operator-5f5f696e7465726e616c5f636f6d70726573735f737472696e675f7568756765696e74/index.md): No description supplied.
- [__internal_compress_string_uinteger](/products/haybarn/functions/releases/duckdb-1.5.5/operator-5f5f696e7465726e616c5f636f6d70726573735f737472696e675f75696e7465676572/index.md): No description supplied.
- [__internal_compress_string_usmallint](/products/haybarn/functions/releases/duckdb-1.5.5/operator-5f5f696e7465726e616c5f636f6d70726573735f737472696e675f75736d616c6c696e74/index.md): No description supplied.
- [__internal_compress_string_utinyint](/products/haybarn/functions/releases/duckdb-1.5.5/operator-5f5f696e7465726e616c5f636f6d70726573735f737472696e675f7574696e79696e74/index.md): No description supplied.
- [__internal_decompress_integral_bigint](/products/haybarn/functions/releases/duckdb-1.5.5/operator-5f5f696e7465726e616c5f6465636f6d70726573735f696e74656772616c5f626967696e74/index.md): No description supplied.
- [__internal_decompress_integral_hugeint](/products/haybarn/functions/releases/duckdb-1.5.5/operator-5f5f696e7465726e616c5f6465636f6d70726573735f696e74656772616c5f68756765696e74/index.md): No description supplied.
- [__internal_decompress_integral_integer](/products/haybarn/functions/releases/duckdb-1.5.5/operator-5f5f696e7465726e616c5f6465636f6d70726573735f696e74656772616c5f696e7465676572/index.md): No description supplied.
- [__internal_decompress_integral_smallint](/products/haybarn/functions/releases/duckdb-1.5.5/operator-5f5f696e7465726e616c5f6465636f6d70726573735f696e74656772616c5f736d616c6c696e74/index.md): No description supplied.
- [__internal_decompress_integral_ubigint](/products/haybarn/functions/releases/duckdb-1.5.5/operator-5f5f696e7465726e616c5f6465636f6d70726573735f696e74656772616c5f75626967696e74/index.md): No description supplied.
- [__internal_decompress_integral_uhugeint](/products/haybarn/functions/releases/duckdb-1.5.5/operator-5f5f696e7465726e616c5f6465636f6d70726573735f696e74656772616c5f7568756765696e74/index.md): No description supplied.
- [__internal_decompress_integral_uinteger](/products/haybarn/functions/releases/duckdb-1.5.5/operator-5f5f696e7465726e616c5f6465636f6d70726573735f696e74656772616c5f75696e7465676572/index.md): No description supplied.
- [__internal_decompress_integral_usmallint](/products/haybarn/functions/releases/duckdb-1.5.5/operator-5f5f696e7465726e616c5f6465636f6d70726573735f696e74656772616c5f75736d616c6c696e74/index.md): No description supplied.
- [__internal_decompress_string](/products/haybarn/functions/releases/duckdb-1.5.5/operator-5f5f696e7465726e616c5f6465636f6d70726573735f737472696e67/index.md): No description supplied.
- [-](/products/haybarn/functions/releases/duckdb-1.5.5/operator-2d/index.md): No description supplied.
- [->>](/products/haybarn/functions/releases/duckdb-1.5.5/operator-2d3e3e/index.md): No description supplied.
- [!__postfix](/products/haybarn/functions/releases/duckdb-1.5.5/operator-215f5f706f7374666978/index.md): Factorial of x. Computes the product of the current integer and all integers below it
- [!~~](/products/haybarn/functions/releases/duckdb-1.5.5/operator-217e7e/index.md): No description supplied.
- [!~~*](/products/haybarn/functions/releases/duckdb-1.5.5/operator-217e7e2a/index.md): No description supplied.
- [@](/products/haybarn/functions/releases/duckdb-1.5.5/operator-40/index.md): Absolute value
- [@>](/products/haybarn/functions/releases/duckdb-1.5.5/operator-403e/index.md): Returns true if all elements of list2 are in list1. NULLs are ignored.
- [*](/products/haybarn/functions/releases/duckdb-1.5.5/operator-2a/index.md): No description supplied.
- [**](/products/haybarn/functions/releases/duckdb-1.5.5/operator-2a2a/index.md): Computes x to the power of y
- [/](/products/haybarn/functions/releases/duckdb-1.5.5/operator-2f/index.md): No description supplied.
- [//](/products/haybarn/functions/releases/duckdb-1.5.5/operator-2f2f/index.md): No description supplied.
- [&](/products/haybarn/functions/releases/duckdb-1.5.5/operator-26/index.md): Bitwise AND
- [&&](/products/haybarn/functions/releases/duckdb-1.5.5/operator-2626/index.md): Returns true if the geometries bounding boxes intersect
- [%](/products/haybarn/functions/releases/duckdb-1.5.5/operator-25/index.md): No description supplied.
- [^](/products/haybarn/functions/releases/duckdb-1.5.5/operator-5e/index.md): Computes x to the power of y
- [^@](/products/haybarn/functions/releases/duckdb-1.5.5/operator-5e40/index.md): Returns `true` if `string` begins with `search_string`.
- [+](/products/haybarn/functions/releases/duckdb-1.5.5/operator-2b/index.md): No description supplied.
- [<->](/products/haybarn/functions/releases/duckdb-1.5.5/operator-3c2d3e/index.md): Calculates the Euclidean distance between two points with coordinates given in two inputs lists of equal length.
- [<@](/products/haybarn/functions/releases/duckdb-1.5.5/operator-3c40/index.md): Returns true if all elements of list2 are in list1. NULLs are ignored.
- [<<](/products/haybarn/functions/releases/duckdb-1.5.5/operator-3c3c/index.md): Bitwise shift left
- [<=>](/products/haybarn/functions/releases/duckdb-1.5.5/operator-3c3d3e/index.md): Computes the cosine distance between two same-sized lists.
- [>>](/products/haybarn/functions/releases/duckdb-1.5.5/operator-3e3e/index.md): Bitwise shift right
- [|](/products/haybarn/functions/releases/duckdb-1.5.5/operator-7c/index.md): Bitwise OR
- [||](/products/haybarn/functions/releases/duckdb-1.5.5/operator-7c7c/index.md): Concatenates two strings, lists, or blobs. Any `NULL` input results in `NULL`. See also `concat(arg1, arg2, ...)` and `list_concat(list1, list2, ...)`.
- [~](/products/haybarn/functions/releases/duckdb-1.5.5/operator-7e/index.md): Bitwise NOT
- [~~](/products/haybarn/functions/releases/duckdb-1.5.5/operator-7e7e/index.md): No description supplied.
- [~~*](/products/haybarn/functions/releases/duckdb-1.5.5/operator-7e7e2a/index.md): No description supplied.
- [~~~](/products/haybarn/functions/releases/duckdb-1.5.5/operator-7e7e7e/index.md): No description supplied.
- [abs](/products/haybarn/functions/releases/duckdb-1.5.5/abs/index.md): Absolute value
- [acos](/products/haybarn/functions/releases/duckdb-1.5.5/acos/index.md): Computes the arccosine of x
- [acosh](/products/haybarn/functions/releases/duckdb-1.5.5/acosh/index.md): Computes the inverse hyperbolic cos of x
- [add](/products/haybarn/functions/releases/duckdb-1.5.5/add/index.md): No description supplied.
- [add_parquet_key](/products/haybarn/functions/releases/duckdb-1.5.5/add_parquet_key/index.md): No description supplied.
- [age](/products/haybarn/functions/releases/duckdb-1.5.5/age/index.md): Subtract arguments, resulting in the time difference between the two timestamps
- [aggregate](/products/haybarn/functions/releases/duckdb-1.5.5/aggregate/index.md): Executes the aggregate function `function_name` on the elements of `list`.
- [ago](/products/haybarn/functions/releases/duckdb-1.5.5/ago/index.md): No description supplied.
- [alias](/products/haybarn/functions/releases/duckdb-1.5.5/alias/index.md): Returns the name of a given expression
- [all_profiling_output](/products/haybarn/functions/releases/duckdb-1.5.5/all_profiling_output/index.md): No description supplied.
- [any_value](/products/haybarn/functions/releases/duckdb-1.5.5/any_value/index.md): Returns the first non-NULL value from arg. This function is affected by ordering.
- [apply](/products/haybarn/functions/releases/duckdb-1.5.5/apply/index.md): Returns a list that is the result of applying the `lambda` function to each element of the input `list`. The return type is defined by the return type of the `lambda` function.
- [approx_count_distinct](/products/haybarn/functions/releases/duckdb-1.5.5/approx_count_distinct/index.md): Computes the approximate count of distinct elements using HyperLogLog.
- [approx_quantile](/products/haybarn/functions/releases/duckdb-1.5.5/approx_quantile/index.md): Computes the approximate quantile using T-Digest.
- [approx_top_k](/products/haybarn/functions/releases/duckdb-1.5.5/approx_top_k/index.md): Finds the k approximately most occurring values in the data set
- [arbitrary](/products/haybarn/functions/releases/duckdb-1.5.5/arbitrary/index.md): Returns the first value (NULL or non-NULL) from arg. This function is affected by ordering.
- [arg_max](/products/haybarn/functions/releases/duckdb-1.5.5/arg_max/index.md): Finds the row with the maximum val. Calculates the non-NULL arg expression at that row.
- [arg_max_null](/products/haybarn/functions/releases/duckdb-1.5.5/arg_max_null/index.md): Finds the row with the maximum val. Calculates the arg expression at that row.
- [arg_max_nulls_last](/products/haybarn/functions/releases/duckdb-1.5.5/arg_max_nulls_last/index.md): Finds the rows with N maximum vals, including nulls. Calculates the arg expression at that row.
- [arg_min](/products/haybarn/functions/releases/duckdb-1.5.5/arg_min/index.md): Finds the row with the minimum val. Calculates the non-NULL arg expression at that row.
- [arg_min_null](/products/haybarn/functions/releases/duckdb-1.5.5/arg_min_null/index.md): Finds the row with the minimum val. Calculates the arg expression at that row.
- [arg_min_nulls_last](/products/haybarn/functions/releases/duckdb-1.5.5/arg_min_nulls_last/index.md): Finds the rows with N minimum vals, including nulls. Calculates the arg expression at that row.
- [argmax](/products/haybarn/functions/releases/duckdb-1.5.5/argmax/index.md): Finds the row with the maximum val. Calculates the non-NULL arg expression at that row.
- [argmin](/products/haybarn/functions/releases/duckdb-1.5.5/argmin/index.md): Finds the row with the minimum val. Calculates the non-NULL arg expression at that row.
- [array_agg](/products/haybarn/functions/releases/duckdb-1.5.5/array_agg/index.md): Returns a LIST containing all the values of a column.
- [array_aggr](/products/haybarn/functions/releases/duckdb-1.5.5/array_aggr/index.md): Executes the aggregate function `function_name` on the elements of `list`.
- [array_aggregate](/products/haybarn/functions/releases/duckdb-1.5.5/array_aggregate/index.md): Executes the aggregate function `function_name` on the elements of `list`.
- [array_append](/products/haybarn/functions/releases/duckdb-1.5.5/array_append/index.md): No description supplied.
- [array_apply](/products/haybarn/functions/releases/duckdb-1.5.5/array_apply/index.md): Returns a list that is the result of applying the `lambda` function to each element of the input `list`. The return type is defined by the return type of the `lambda` function.
- [array_cat](/products/haybarn/functions/releases/duckdb-1.5.5/array_cat/index.md): Concatenates lists. `NULL` inputs are skipped. See also operator `||`.
- [array_concat](/products/haybarn/functions/releases/duckdb-1.5.5/array_concat/index.md): Concatenates lists. `NULL` inputs are skipped. See also operator `||`.
- [array_contains](/products/haybarn/functions/releases/duckdb-1.5.5/array_contains/index.md): Returns true if the list contains the element.
- [array_cosine_distance](/products/haybarn/functions/releases/duckdb-1.5.5/array_cosine_distance/index.md): Computes the cosine distance between two arrays of the same size. The array elements can not be `NULL`. The arrays can have any size as long as the size is the same for both arguments.
- [array_cosine_similarity](/products/haybarn/functions/releases/duckdb-1.5.5/array_cosine_similarity/index.md): Computes the cosine similarity between two arrays of the same size. The array elements can not be `NULL`. The arrays can have any size as long as the size is the same for both arguments.
- [array_cross_product](/products/haybarn/functions/releases/duckdb-1.5.5/array_cross_product/index.md): Computes the cross product of two arrays of size 3. The array elements can not be `NULL`.
- [array_distance](/products/haybarn/functions/releases/duckdb-1.5.5/array_distance/index.md): Computes the distance between two arrays of the same size. The array elements can not be `NULL`. The arrays can have any size as long as the size is the same for both arguments.
- [array_distinct](/products/haybarn/functions/releases/duckdb-1.5.5/array_distinct/index.md): Removes all duplicates and `NULL` values from a list. Does not preserve the original order.
- [array_dot_product](/products/haybarn/functions/releases/duckdb-1.5.5/array_dot_product/index.md): Computes the inner product between two arrays of the same size. The array elements can not be `NULL`. The arrays can have any size as long as the size is the same for both arguments.
- [array_extract](/products/haybarn/functions/releases/duckdb-1.5.5/array_extract/index.md): Extracts a single character from a `string` using a (1-based) `index`.
- [array_filter](/products/haybarn/functions/releases/duckdb-1.5.5/array_filter/index.md): Constructs a list from those elements of the input `list` for which the `lambda` function returns `true`. DuckDB must be able to cast the `lambda` function's return type to `BOOL`. The return type of `list_filter` is the same as the input list's.
- [array_grade_up](/products/haybarn/functions/releases/duckdb-1.5.5/array_grade_up/index.md): Works like list_sort, but the results are the indexes that correspond to the position in the original list instead of the actual values.
- [array_has](/products/haybarn/functions/releases/duckdb-1.5.5/array_has/index.md): Returns true if the list contains the element.
- [array_has_all](/products/haybarn/functions/releases/duckdb-1.5.5/array_has_all/index.md): Returns true if all elements of list2 are in list1. NULLs are ignored.
- [array_has_any](/products/haybarn/functions/releases/duckdb-1.5.5/array_has_any/index.md): Returns true if the lists have any element in common. NULLs are ignored.
- [array_indexof](/products/haybarn/functions/releases/duckdb-1.5.5/array_indexof/index.md): Returns the index of the `element` if the `list` contains the `element`. If the `element` is not found, it returns `NULL`.
- [array_inner_product](/products/haybarn/functions/releases/duckdb-1.5.5/array_inner_product/index.md): Computes the inner product between two arrays of the same size. The array elements can not be `NULL`. The arrays can have any size as long as the size is the same for both arguments.
- [array_intersect](/products/haybarn/functions/releases/duckdb-1.5.5/array_intersect/index.md): Returns a list containing the distinct elements that are present in both `list1` and `list2`.
- [array_length](/products/haybarn/functions/releases/duckdb-1.5.5/array_length/index.md): `array_length` for lists with dimensions other than 1 not implemented
- [array_negative_dot_product](/products/haybarn/functions/releases/duckdb-1.5.5/array_negative_dot_product/index.md): Computes the negative inner product between two arrays of the same size. The array elements can not be `NULL`. The arrays can have any size as long as the size is the same for both arguments.
- [array_negative_inner_product](/products/haybarn/functions/releases/duckdb-1.5.5/array_negative_inner_product/index.md): Computes the negative inner product between two arrays of the same size. The array elements can not be `NULL`. The arrays can have any size as long as the size is the same for both arguments.
- [array_pop_back](/products/haybarn/functions/releases/duckdb-1.5.5/array_pop_back/index.md): No description supplied.
- [array_pop_front](/products/haybarn/functions/releases/duckdb-1.5.5/array_pop_front/index.md): No description supplied.
- [array_position](/products/haybarn/functions/releases/duckdb-1.5.5/array_position/index.md): Returns the index of the `element` if the `list` contains the `element`. If the `element` is not found, it returns `NULL`.
- [array_prepend](/products/haybarn/functions/releases/duckdb-1.5.5/array_prepend/index.md): No description supplied.
- [array_push_back](/products/haybarn/functions/releases/duckdb-1.5.5/array_push_back/index.md): No description supplied.
- [array_push_front](/products/haybarn/functions/releases/duckdb-1.5.5/array_push_front/index.md): No description supplied.
- [array_reduce](/products/haybarn/functions/releases/duckdb-1.5.5/array_reduce/index.md): Reduces all elements of the input `list` into a single scalar value by executing the `lambda` function on a running result and the next list element. The `lambda` function has an optional `initial_value` argument.
- [array_resize](/products/haybarn/functions/releases/duckdb-1.5.5/array_resize/index.md): Resizes the `list` to contain `size` elements. Initializes new elements with `value` or `NULL` if `value` is not set.
- [array_reverse](/products/haybarn/functions/releases/duckdb-1.5.5/array_reverse/index.md): No description supplied.
- [array_reverse_sort](/products/haybarn/functions/releases/duckdb-1.5.5/array_reverse_sort/index.md): Sorts the elements of the list in reverse order.
- [array_select](/products/haybarn/functions/releases/duckdb-1.5.5/array_select/index.md): Returns a list based on the elements selected by the `index_list`.
- [array_slice](/products/haybarn/functions/releases/duckdb-1.5.5/array_slice/index.md): list_slice with added step feature.
- [array_sort](/products/haybarn/functions/releases/duckdb-1.5.5/array_sort/index.md): Sorts the elements of the list.
- [array_to_json](/products/haybarn/functions/releases/duckdb-1.5.5/array_to_json/index.md): No description supplied.
- [array_to_string](/products/haybarn/functions/releases/duckdb-1.5.5/array_to_string/index.md): No description supplied.
- [array_to_string_comma_default](/products/haybarn/functions/releases/duckdb-1.5.5/array_to_string_comma_default/index.md): No description supplied.
- [array_transform](/products/haybarn/functions/releases/duckdb-1.5.5/array_transform/index.md): Returns a list that is the result of applying the `lambda` function to each element of the input `list`. The return type is defined by the return type of the `lambda` function.
- [array_unique](/products/haybarn/functions/releases/duckdb-1.5.5/array_unique/index.md): Counts the unique elements of a `list`.
- [array_value](/products/haybarn/functions/releases/duckdb-1.5.5/array_value/index.md): Creates an `ARRAY` containing the argument values.
- [array_where](/products/haybarn/functions/releases/duckdb-1.5.5/array_where/index.md): Returns a list with the `BOOLEAN`s in `mask_list` applied as a mask to the `value_list`.
- [array_zip](/products/haybarn/functions/releases/duckdb-1.5.5/array_zip/index.md): Zips n `LIST`s to a new `LIST` whose length will be that of the longest list. Its elements are structs of n elements from each list `list_1`, …, `list_n`, missing elements are replaced with `NULL`. If `truncate` is set, all lists are truncated to the smallest list length.
- [arrow_scan](/products/haybarn/functions/releases/duckdb-1.5.5/arrow_scan/index.md): No description supplied.
- [arrow_scan_dumb](/products/haybarn/functions/releases/duckdb-1.5.5/arrow_scan_dumb/index.md): No description supplied.
- [ascii](/products/haybarn/functions/releases/duckdb-1.5.5/ascii/index.md): Returns an integer that represents the Unicode code point of the first character of the `string`.
- [asin](/products/haybarn/functions/releases/duckdb-1.5.5/asin/index.md): Computes the arcsine of x
- [asinh](/products/haybarn/functions/releases/duckdb-1.5.5/asinh/index.md): Computes the inverse hyperbolic sin of x
- [atan](/products/haybarn/functions/releases/duckdb-1.5.5/atan/index.md): Computes the arctangent of x
- [atan2](/products/haybarn/functions/releases/duckdb-1.5.5/atan2/index.md): Computes the arctangent (y, x)
- [atanh](/products/haybarn/functions/releases/duckdb-1.5.5/atanh/index.md): Computes the inverse hyperbolic tan of x
- [avg](/products/haybarn/functions/releases/duckdb-1.5.5/avg/index.md): Calculates the average value for all tuples in x.
- [bar](/products/haybarn/functions/releases/duckdb-1.5.5/bar/index.md): Draws a band whose width is proportional to (`x - min`) and equal to `width` characters when `x` = `max`. `width` defaults to 80.
- [base64](/products/haybarn/functions/releases/duckdb-1.5.5/base64/index.md): Converts a `blob` to a base64 encoded string.
- [bin](/products/haybarn/functions/releases/duckdb-1.5.5/bin/index.md): Converts the `string` to binary representation.
- [bit_and](/products/haybarn/functions/releases/duckdb-1.5.5/bit_and/index.md): Returns the bitwise AND of all bits in a given expression.
- [bit_count](/products/haybarn/functions/releases/duckdb-1.5.5/bit_count/index.md): Returns the number of bits that are set
- [bit_length](/products/haybarn/functions/releases/duckdb-1.5.5/bit_length/index.md): Returns the bit-length of the `bit` argument.
- [bit_or](/products/haybarn/functions/releases/duckdb-1.5.5/bit_or/index.md): Returns the bitwise OR of all bits in a given expression.
- [bit_position](/products/haybarn/functions/releases/duckdb-1.5.5/bit_position/index.md): Returns first starting index of the specified substring within bits, or zero if it is not present. The first (leftmost) bit is indexed 1
- [bit_xor](/products/haybarn/functions/releases/duckdb-1.5.5/bit_xor/index.md): Returns the bitwise XOR of all bits in a given expression.
- [bitstring](/products/haybarn/functions/releases/duckdb-1.5.5/bitstring/index.md): Pads the bitstring until the specified length
- [bitstring_agg](/products/haybarn/functions/releases/duckdb-1.5.5/bitstring_agg/index.md): Returns a bitstring with bits set for each distinct value.
- [bool_and](/products/haybarn/functions/releases/duckdb-1.5.5/bool_and/index.md): Returns TRUE if every input value is TRUE, otherwise FALSE.
- [bool_or](/products/haybarn/functions/releases/duckdb-1.5.5/bool_or/index.md): Returns TRUE if any input value is TRUE, otherwise FALSE.
- [can_cast_implicitly](/products/haybarn/functions/releases/duckdb-1.5.5/can_cast_implicitly/index.md): Whether or not we can implicitly cast from the source type to the other type
- [cardinality](/products/haybarn/functions/releases/duckdb-1.5.5/cardinality/index.md): Returns the size of the map (or the number of entries in the map)
- [cast_to_type](/products/haybarn/functions/releases/duckdb-1.5.5/cast_to_type/index.md): Casts the first argument to the type of the second argument
- [cbrt](/products/haybarn/functions/releases/duckdb-1.5.5/cbrt/index.md): Returns the cube root of x
- [ceil](/products/haybarn/functions/releases/duckdb-1.5.5/ceil/index.md): Rounds the number up
- [ceiling](/products/haybarn/functions/releases/duckdb-1.5.5/ceiling/index.md): Rounds the number up
- [century](/products/haybarn/functions/releases/duckdb-1.5.5/century/index.md): Extract the century component from a date or timestamp
- [char_length](/products/haybarn/functions/releases/duckdb-1.5.5/char_length/index.md): Returns the bit-length of the `bit` argument.
- [character_length](/products/haybarn/functions/releases/duckdb-1.5.5/character_length/index.md): Returns the bit-length of the `bit` argument.
- [check_peg_parser](/products/haybarn/functions/releases/duckdb-1.5.5/check_peg_parser/index.md): No description supplied.
- [checkpoint](/products/haybarn/functions/releases/duckdb-1.5.5/checkpoint/index.md): No description supplied.
- [chr](/products/haybarn/functions/releases/duckdb-1.5.5/chr/index.md): Returns a character which is corresponding the ASCII code value or Unicode code point.
- [collations](/products/haybarn/functions/releases/duckdb-1.5.5/collations/index.md): No description supplied.
- [combine](/products/haybarn/functions/releases/duckdb-1.5.5/combine/index.md): No description supplied.
- [concat](/products/haybarn/functions/releases/duckdb-1.5.5/concat/index.md): Concatenates multiple strings or lists. `NULL` inputs are skipped. See also operator `||`.
- [concat_ws](/products/haybarn/functions/releases/duckdb-1.5.5/concat_ws/index.md): Concatenates many strings, separated by `separator`. `NULL` inputs are skipped.
- [constant_or_null](/products/haybarn/functions/releases/duckdb-1.5.5/constant_or_null/index.md): If arg2 is NULL, return NULL. Otherwise, return arg1.
- [contains](/products/haybarn/functions/releases/duckdb-1.5.5/contains/index.md): Returns `true` if `search_string` is found within `string`.
- [copy_database](/products/haybarn/functions/releases/duckdb-1.5.5/copy_database/index.md): No description supplied.
- [corr](/products/haybarn/functions/releases/duckdb-1.5.5/corr/index.md): Returns the correlation coefficient for non-NULL pairs in a group.
- [cos](/products/haybarn/functions/releases/duckdb-1.5.5/cos/index.md): Computes the cos of x
- [cosh](/products/haybarn/functions/releases/duckdb-1.5.5/cosh/index.md): Computes the hyperbolic cos of x
- [cot](/products/haybarn/functions/releases/duckdb-1.5.5/cot/index.md): Computes the cotangent of x
- [count](/products/haybarn/functions/releases/duckdb-1.5.5/count/index.md): Returns the number of non-NULL values in arg.
- [count_if](/products/haybarn/functions/releases/duckdb-1.5.5/count_if/index.md): Counts the total number of TRUE values for a boolean column
- [count_star](/products/haybarn/functions/releases/duckdb-1.5.5/count_star/index.md): No description supplied.
- [countif](/products/haybarn/functions/releases/duckdb-1.5.5/countif/index.md): Counts the total number of TRUE values for a boolean column
- [covar_pop](/products/haybarn/functions/releases/duckdb-1.5.5/covar_pop/index.md): Returns the population covariance of input values.
- [covar_samp](/products/haybarn/functions/releases/duckdb-1.5.5/covar_samp/index.md): Returns the sample covariance for non-NULL pairs in a group.
- [create_sort_key](/products/haybarn/functions/releases/duckdb-1.5.5/create_sort_key/index.md): Constructs a binary-comparable sort key based on a set of input parameters and sort qualifiers
- [cume_dist](/products/haybarn/functions/releases/duckdb-1.5.5/cume_dist/index.md): No description supplied.
- [current_catalog](/products/haybarn/functions/releases/duckdb-1.5.5/current_catalog/index.md): No description supplied.
- [current_connection_id](/products/haybarn/functions/releases/duckdb-1.5.5/current_connection_id/index.md): Get the current connection_id
- [current_database](/products/haybarn/functions/releases/duckdb-1.5.5/current_database/index.md): Returns the name of the currently active database
- [current_date](/products/haybarn/functions/releases/duckdb-1.5.5/current_date/index.md): No description supplied.
- [current_localtime](/products/haybarn/functions/releases/duckdb-1.5.5/current_localtime/index.md): No description supplied.
- [current_localtimestamp](/products/haybarn/functions/releases/duckdb-1.5.5/current_localtimestamp/index.md): No description supplied.
- [current_query](/products/haybarn/functions/releases/duckdb-1.5.5/current_query/index.md): Returns the current query as a string
- [current_query_id](/products/haybarn/functions/releases/duckdb-1.5.5/current_query_id/index.md): Get the current query_id
- [current_role](/products/haybarn/functions/releases/duckdb-1.5.5/current_role/index.md): No description supplied.
- [current_schema](/products/haybarn/functions/releases/duckdb-1.5.5/current_schema/index.md): Returns the name of the currently active schema. Default is main
- [current_schemas](/products/haybarn/functions/releases/duckdb-1.5.5/current_schemas/index.md): Returns list of schemas. Pass a parameter of True to include implicit schemas
- [current_setting](/products/haybarn/functions/releases/duckdb-1.5.5/current_setting/index.md): Returns the current value of the configuration setting
- [current_transaction_id](/products/haybarn/functions/releases/duckdb-1.5.5/current_transaction_id/index.md): Get the current global transaction_id
- [current_user](/products/haybarn/functions/releases/duckdb-1.5.5/current_user/index.md): No description supplied.
- [currval](/products/haybarn/functions/releases/duckdb-1.5.5/currval/index.md): Return the current value of the sequence. Note that nextval must be called at least once prior to calling currval.
- [damerau_levenshtein](/products/haybarn/functions/releases/duckdb-1.5.5/damerau_levenshtein/index.md): Extension of Levenshtein distance to also include transposition of adjacent characters as an allowed edit operation. In other words, the minimum number of edit operations (insertions, deletions, substitutions or transpositions) required to change one string to another. Characters of different cases (e.g., `a` and `A`) are considered different.
- [database_list](/products/haybarn/functions/releases/duckdb-1.5.5/database_list/index.md): No description supplied.
- [database_size](/products/haybarn/functions/releases/duckdb-1.5.5/database_size/index.md): No description supplied.
- [date_add](/products/haybarn/functions/releases/duckdb-1.5.5/date_add/index.md): No description supplied.
- [date_diff](/products/haybarn/functions/releases/duckdb-1.5.5/date_diff/index.md): The number of partition boundaries between the timestamps
- [date_part](/products/haybarn/functions/releases/duckdb-1.5.5/date_part/index.md): Get subfield (equivalent to extract)
- [date_sub](/products/haybarn/functions/releases/duckdb-1.5.5/date_sub/index.md): The number of complete partitions between the timestamps
- [date_trunc](/products/haybarn/functions/releases/duckdb-1.5.5/date_trunc/index.md): Truncate to specified precision
- [datediff](/products/haybarn/functions/releases/duckdb-1.5.5/datediff/index.md): The number of partition boundaries between the timestamps
- [datepart](/products/haybarn/functions/releases/duckdb-1.5.5/datepart/index.md): Get subfield (equivalent to extract)
- [datesub](/products/haybarn/functions/releases/duckdb-1.5.5/datesub/index.md): The number of complete partitions between the timestamps
- [datetrunc](/products/haybarn/functions/releases/duckdb-1.5.5/datetrunc/index.md): Truncate to specified precision
- [day](/products/haybarn/functions/releases/duckdb-1.5.5/day/index.md): Extract the day component from a date or timestamp
- [dayname](/products/haybarn/functions/releases/duckdb-1.5.5/dayname/index.md): The (English) name of the weekday
- [dayofmonth](/products/haybarn/functions/releases/duckdb-1.5.5/dayofmonth/index.md): Extract the dayofmonth component from a date or timestamp
- [dayofweek](/products/haybarn/functions/releases/duckdb-1.5.5/dayofweek/index.md): Extract the dayofweek component from a date or timestamp
- [dayofyear](/products/haybarn/functions/releases/duckdb-1.5.5/dayofyear/index.md): Extract the dayofyear component from a date or timestamp
- [days_in_month](/products/haybarn/functions/releases/duckdb-1.5.5/days_in_month/index.md): No description supplied.
- [decade](/products/haybarn/functions/releases/duckdb-1.5.5/decade/index.md): Extract the decade component from a date or timestamp
- [decode](/products/haybarn/functions/releases/duckdb-1.5.5/decode/index.md): Converts `blob` to `VARCHAR`. Invalid UTF-8 is handled based on the error behavior argument. Can be 'strict' (default, fail), 'replace' to replace invalid characters with '?', or 'ignore' to skip invalid characters.
- [degrees](/products/haybarn/functions/releases/duckdb-1.5.5/degrees/index.md): Converts radians to degrees
- [dense_rank](/products/haybarn/functions/releases/duckdb-1.5.5/dense_rank/index.md): No description supplied.
- [disable_checkpoint_on_shutdown](/products/haybarn/functions/releases/duckdb-1.5.5/disable_checkpoint_on_shutdown/index.md): No description supplied.
- [disable_logging](/products/haybarn/functions/releases/duckdb-1.5.5/disable_logging/index.md): No description supplied.
- [disable_object_cache](/products/haybarn/functions/releases/duckdb-1.5.5/disable_object_cache/index.md): No description supplied.
- [disable_optimizer](/products/haybarn/functions/releases/duckdb-1.5.5/disable_optimizer/index.md): No description supplied.
- [disable_peg_parser](/products/haybarn/functions/releases/duckdb-1.5.5/disable_peg_parser/index.md): No description supplied.
- [disable_print_progress_bar](/products/haybarn/functions/releases/duckdb-1.5.5/disable_print_progress_bar/index.md): No description supplied.
- [disable_profile](/products/haybarn/functions/releases/duckdb-1.5.5/disable_profile/index.md): No description supplied.
- [disable_profiling](/products/haybarn/functions/releases/duckdb-1.5.5/disable_profiling/index.md): No description supplied.
- [disable_progress_bar](/products/haybarn/functions/releases/duckdb-1.5.5/disable_progress_bar/index.md): No description supplied.
- [disable_verification](/products/haybarn/functions/releases/duckdb-1.5.5/disable_verification/index.md): No description supplied.
- [disable_verify_external](/products/haybarn/functions/releases/duckdb-1.5.5/disable_verify_external/index.md): No description supplied.
- [disable_verify_fetch_row](/products/haybarn/functions/releases/duckdb-1.5.5/disable_verify_fetch_row/index.md): No description supplied.
- [disable_verify_parallelism](/products/haybarn/functions/releases/duckdb-1.5.5/disable_verify_parallelism/index.md): No description supplied.
- [disable_verify_serializer](/products/haybarn/functions/releases/duckdb-1.5.5/disable_verify_serializer/index.md): No description supplied.
- [divide](/products/haybarn/functions/releases/duckdb-1.5.5/divide/index.md): No description supplied.
- [duckdb_approx_database_count](/products/haybarn/functions/releases/duckdb-1.5.5/duckdb_approx_database_count/index.md): No description supplied.
- [duckdb_columns](/products/haybarn/functions/releases/duckdb-1.5.5/duckdb_columns/index.md): No description supplied.
- [duckdb_connection_count](/products/haybarn/functions/releases/duckdb-1.5.5/duckdb_connection_count/index.md): No description supplied.
- [duckdb_constraints](/products/haybarn/functions/releases/duckdb-1.5.5/duckdb_constraints/index.md): No description supplied.
- [duckdb_coordinate_systems](/products/haybarn/functions/releases/duckdb-1.5.5/duckdb_coordinate_systems/index.md): No description supplied.
- [duckdb_databases](/products/haybarn/functions/releases/duckdb-1.5.5/duckdb_databases/index.md): No description supplied.
- [duckdb_dependencies](/products/haybarn/functions/releases/duckdb-1.5.5/duckdb_dependencies/index.md): No description supplied.
- [duckdb_extensions](/products/haybarn/functions/releases/duckdb-1.5.5/duckdb_extensions/index.md): No description supplied.
- [duckdb_external_file_cache](/products/haybarn/functions/releases/duckdb-1.5.5/duckdb_external_file_cache/index.md): No description supplied.
- [duckdb_functions](/products/haybarn/functions/releases/duckdb-1.5.5/duckdb_functions/index.md): No description supplied.
- [duckdb_indexes](/products/haybarn/functions/releases/duckdb-1.5.5/duckdb_indexes/index.md): No description supplied.
- [duckdb_keywords](/products/haybarn/functions/releases/duckdb-1.5.5/duckdb_keywords/index.md): No description supplied.
- [duckdb_log_contexts](/products/haybarn/functions/releases/duckdb-1.5.5/duckdb_log_contexts/index.md): No description supplied.
- [duckdb_logs](/products/haybarn/functions/releases/duckdb-1.5.5/duckdb_logs/index.md): No description supplied.
- [duckdb_logs_parsed](/products/haybarn/functions/releases/duckdb-1.5.5/duckdb_logs_parsed/index.md): No description supplied.
- [duckdb_memory](/products/haybarn/functions/releases/duckdb-1.5.5/duckdb_memory/index.md): No description supplied.
- [duckdb_optimizers](/products/haybarn/functions/releases/duckdb-1.5.5/duckdb_optimizers/index.md): No description supplied.
- [duckdb_prepared_statements](/products/haybarn/functions/releases/duckdb-1.5.5/duckdb_prepared_statements/index.md): No description supplied.
- [duckdb_profiling_settings](/products/haybarn/functions/releases/duckdb-1.5.5/duckdb_profiling_settings/index.md): No description supplied.
- [duckdb_schemas](/products/haybarn/functions/releases/duckdb-1.5.5/duckdb_schemas/index.md): No description supplied.
- [duckdb_secret_types](/products/haybarn/functions/releases/duckdb-1.5.5/duckdb_secret_types/index.md): No description supplied.
- [duckdb_secrets](/products/haybarn/functions/releases/duckdb-1.5.5/duckdb_secrets/index.md): No description supplied.
- [duckdb_sequences](/products/haybarn/functions/releases/duckdb-1.5.5/duckdb_sequences/index.md): No description supplied.
- [duckdb_settings](/products/haybarn/functions/releases/duckdb-1.5.5/duckdb_settings/index.md): No description supplied.
- [duckdb_table_sample](/products/haybarn/functions/releases/duckdb-1.5.5/duckdb_table_sample/index.md): No description supplied.
- [duckdb_tables](/products/haybarn/functions/releases/duckdb-1.5.5/duckdb_tables/index.md): No description supplied.
- [duckdb_temporary_files](/products/haybarn/functions/releases/duckdb-1.5.5/duckdb_temporary_files/index.md): No description supplied.
- [duckdb_types](/products/haybarn/functions/releases/duckdb-1.5.5/duckdb_types/index.md): No description supplied.
- [duckdb_variables](/products/haybarn/functions/releases/duckdb-1.5.5/duckdb_variables/index.md): No description supplied.
- [duckdb_views](/products/haybarn/functions/releases/duckdb-1.5.5/duckdb_views/index.md): No description supplied.
- [editdist3](/products/haybarn/functions/releases/duckdb-1.5.5/editdist3/index.md): The minimum number of single-character edits (insertions, deletions or substitutions) required to change one string to the other. Characters of different cases (e.g., `a` and `A`) are considered different.
- [element_at](/products/haybarn/functions/releases/duckdb-1.5.5/element_at/index.md): Returns a list containing the value for a given key or an empty list if the key is not contained in the map. The type of the key provided in the second parameter must match the type of the map’s keys else an error is returned
- [enable_checkpoint_on_shutdown](/products/haybarn/functions/releases/duckdb-1.5.5/enable_checkpoint_on_shutdown/index.md): No description supplied.
- [enable_logging](/products/haybarn/functions/releases/duckdb-1.5.5/enable_logging/index.md): No description supplied.
- [enable_object_cache](/products/haybarn/functions/releases/duckdb-1.5.5/enable_object_cache/index.md): No description supplied.
- [enable_optimizer](/products/haybarn/functions/releases/duckdb-1.5.5/enable_optimizer/index.md): No description supplied.
- [enable_peg_parser](/products/haybarn/functions/releases/duckdb-1.5.5/enable_peg_parser/index.md): No description supplied.
- [enable_print_progress_bar](/products/haybarn/functions/releases/duckdb-1.5.5/enable_print_progress_bar/index.md): No description supplied.
- [enable_profile](/products/haybarn/functions/releases/duckdb-1.5.5/enable_profile/index.md): No description supplied.
- [enable_profiling](/products/haybarn/functions/releases/duckdb-1.5.5/enable_profiling/index.md): No description supplied.
- [enable_progress_bar](/products/haybarn/functions/releases/duckdb-1.5.5/enable_progress_bar/index.md): No description supplied.
- [enable_verification](/products/haybarn/functions/releases/duckdb-1.5.5/enable_verification/index.md): No description supplied.
- [encode](/products/haybarn/functions/releases/duckdb-1.5.5/encode/index.md): Converts the `string` to `BLOB`. Converts UTF-8 characters into literal encoding.
- [ends_with](/products/haybarn/functions/releases/duckdb-1.5.5/ends_with/index.md): Returns `true` if `string` ends with `search_string`.
- [entropy](/products/haybarn/functions/releases/duckdb-1.5.5/entropy/index.md): Returns the log-2 entropy of count input-values.
- [enum_code](/products/haybarn/functions/releases/duckdb-1.5.5/enum_code/index.md): Returns the numeric value backing the given enum value
- [enum_first](/products/haybarn/functions/releases/duckdb-1.5.5/enum_first/index.md): Returns the first value of the input enum type
- [enum_last](/products/haybarn/functions/releases/duckdb-1.5.5/enum_last/index.md): Returns the last value of the input enum type
- [enum_range](/products/haybarn/functions/releases/duckdb-1.5.5/enum_range/index.md): Returns all values of the input enum type as an array
- [enum_range_boundary](/products/haybarn/functions/releases/duckdb-1.5.5/enum_range_boundary/index.md): Returns the range between the two given enum values as an array. The values must be of the same enum type. When the first parameter is NULL, the result starts with the first value of the enum type. When the second parameter is NULL, the result ends with the last value of the enum type
- [epoch](/products/haybarn/functions/releases/duckdb-1.5.5/epoch/index.md): Extract the epoch component from a temporal type
- [epoch_ms](/products/haybarn/functions/releases/duckdb-1.5.5/epoch_ms/index.md): Extract the epoch component in milliseconds from a temporal type
- [epoch_ns](/products/haybarn/functions/releases/duckdb-1.5.5/epoch_ns/index.md): Extract the epoch component in nanoseconds from a temporal type
- [epoch_us](/products/haybarn/functions/releases/duckdb-1.5.5/epoch_us/index.md): Extract the epoch component in microseconds from a temporal type
- [equi_width_bins](/products/haybarn/functions/releases/duckdb-1.5.5/equi_width_bins/index.md): Generates bin_count equi-width bins between the min and max. If enabled nice_rounding makes the numbers more readable/less jagged
- [era](/products/haybarn/functions/releases/duckdb-1.5.5/era/index.md): Extract the era component from a date or timestamp
- [error](/products/haybarn/functions/releases/duckdb-1.5.5/error/index.md): Throws the given error message
- [even](/products/haybarn/functions/releases/duckdb-1.5.5/even/index.md): Rounds x to next even number by rounding away from zero
- [exp](/products/haybarn/functions/releases/duckdb-1.5.5/exp/index.md): Computes e to the power of x
- [extension_versions](/products/haybarn/functions/releases/duckdb-1.5.5/extension_versions/index.md): No description supplied.
- [factorial](/products/haybarn/functions/releases/duckdb-1.5.5/factorial/index.md): Factorial of x. Computes the product of the current integer and all integers below it
- [favg](/products/haybarn/functions/releases/duckdb-1.5.5/favg/index.md): Calculates the average using a more accurate floating point summation (Kahan Sum)
- [fdiv](/products/haybarn/functions/releases/duckdb-1.5.5/fdiv/index.md): No description supplied.
- [fill](/products/haybarn/functions/releases/duckdb-1.5.5/fill/index.md): No description supplied.
- [filter](/products/haybarn/functions/releases/duckdb-1.5.5/filter/index.md): Constructs a list from those elements of the input `list` for which the `lambda` function returns `true`. DuckDB must be able to cast the `lambda` function's return type to `BOOL`. The return type of `list_filter` is the same as the input list's.
- [finalize](/products/haybarn/functions/releases/duckdb-1.5.5/finalize/index.md): No description supplied.
- [first](/products/haybarn/functions/releases/duckdb-1.5.5/first/index.md): Returns the first value (NULL or non-NULL) from arg. This function is affected by ordering.
- [first_value](/products/haybarn/functions/releases/duckdb-1.5.5/first_value/index.md): No description supplied.
- [flatten](/products/haybarn/functions/releases/duckdb-1.5.5/flatten/index.md): Flattens a nested list by one level.
- [floor](/products/haybarn/functions/releases/duckdb-1.5.5/floor/index.md): Rounds the number down
- [fmod](/products/haybarn/functions/releases/duckdb-1.5.5/fmod/index.md): No description supplied.
- [force_checkpoint](/products/haybarn/functions/releases/duckdb-1.5.5/force_checkpoint/index.md): No description supplied.
- [format](/products/haybarn/functions/releases/duckdb-1.5.5/format/index.md): Formats a string using the fmt syntax.
- [format_bytes](/products/haybarn/functions/releases/duckdb-1.5.5/format_bytes/index.md): Converts `integer` to a human-readable representation using units based on powers of 2 (KiB, MiB, GiB, etc.).
- [formatReadableDecimalSize](/products/haybarn/functions/releases/duckdb-1.5.5/operator-666f726d61745265616461626c65446563696d616c53697a65/index.md): Converts `integer` to a human-readable representation using units based on powers of 10 (KB, MB, GB, etc.).
- [formatReadableSize](/products/haybarn/functions/releases/duckdb-1.5.5/operator-666f726d61745265616461626c6553697a65/index.md): Converts `integer` to a human-readable representation using units based on powers of 2 (KiB, MiB, GiB, etc.).
- [from_base64](/products/haybarn/functions/releases/duckdb-1.5.5/from_base64/index.md): Converts a base64 encoded `string` to a character string (`BLOB`).
- [from_binary](/products/haybarn/functions/releases/duckdb-1.5.5/from_binary/index.md): Converts a `value` from binary representation to a blob.
- [from_hex](/products/haybarn/functions/releases/duckdb-1.5.5/from_hex/index.md): Converts a `value` from hexadecimal representation to a blob.
- [from_json](/products/haybarn/functions/releases/duckdb-1.5.5/from_json/index.md): No description supplied.
- [from_json_strict](/products/haybarn/functions/releases/duckdb-1.5.5/from_json_strict/index.md): No description supplied.
- [fsum](/products/haybarn/functions/releases/duckdb-1.5.5/fsum/index.md): Calculates the sum using a more accurate floating point summation (Kahan Sum).
- [functions](/products/haybarn/functions/releases/duckdb-1.5.5/functions/index.md): No description supplied.
- [gamma](/products/haybarn/functions/releases/duckdb-1.5.5/gamma/index.md): Interpolation of (x-1) factorial (so decimal inputs are allowed)
- [gcd](/products/haybarn/functions/releases/duckdb-1.5.5/gcd/index.md): Computes the greatest common divisor of x and y
- [gen_random_uuid](/products/haybarn/functions/releases/duckdb-1.5.5/gen_random_uuid/index.md): Returns a random UUID v4 similar to this: eeccb8c5-9943-b2bb-bb5e-222f4e14b687
- [generate_series](/products/haybarn/functions/releases/duckdb-1.5.5/generate_series/index.md): Creates a list of values between `start` and `stop` - the stop parameter is inclusive.
- [generate_subscripts](/products/haybarn/functions/releases/duckdb-1.5.5/generate_subscripts/index.md): No description supplied.
- [geomean](/products/haybarn/functions/releases/duckdb-1.5.5/geomean/index.md): No description supplied.
- [geometric_mean](/products/haybarn/functions/releases/duckdb-1.5.5/geometric_mean/index.md): No description supplied.
- [get_bit](/products/haybarn/functions/releases/duckdb-1.5.5/get_bit/index.md): Extracts the nth bit from bitstring; the first (leftmost) bit is indexed 0
- [get_block_size](/products/haybarn/functions/releases/duckdb-1.5.5/get_block_size/index.md): No description supplied.
- [get_current_time](/products/haybarn/functions/releases/duckdb-1.5.5/get_current_time/index.md): No description supplied.
- [get_current_timestamp](/products/haybarn/functions/releases/duckdb-1.5.5/get_current_timestamp/index.md): Returns the current timestamp
- [get_type](/products/haybarn/functions/releases/duckdb-1.5.5/get_type/index.md): Returns the type of the result of the expression
- [getenv](/products/haybarn/functions/releases/duckdb-1.5.5/getenv/index.md): No description supplied.
- [getvariable](/products/haybarn/functions/releases/duckdb-1.5.5/getvariable/index.md): No description supplied.
- [glob](/products/haybarn/functions/releases/duckdb-1.5.5/glob/index.md): No description supplied.
- [grade_up](/products/haybarn/functions/releases/duckdb-1.5.5/grade_up/index.md): Works like list_sort, but the results are the indexes that correspond to the position in the original list instead of the actual values.
- [greatest](/products/haybarn/functions/releases/duckdb-1.5.5/greatest/index.md): Returns the largest value. For strings lexicographical ordering is used. Note that lowercase characters are considered “larger” than uppercase characters and collations are not supported.
- [greatest_common_divisor](/products/haybarn/functions/releases/duckdb-1.5.5/greatest_common_divisor/index.md): Computes the greatest common divisor of x and y
- [group_concat](/products/haybarn/functions/releases/duckdb-1.5.5/group_concat/index.md): Concatenates the column string values with an optional separator.
- [hamming](/products/haybarn/functions/releases/duckdb-1.5.5/hamming/index.md): The Hamming distance between to strings, i.e., the number of positions with different characters for two strings of equal length. Strings must be of equal length. Characters of different cases (e.g., `a` and `A`) are considered different.
- [hash](/products/haybarn/functions/releases/duckdb-1.5.5/hash/index.md): Returns a `UBIGINT` with the hash of the `value`. Note that this is not a cryptographic hash.
- [hex](/products/haybarn/functions/releases/duckdb-1.5.5/hex/index.md): Converts `blob` to `VARCHAR` using hexadecimal encoding.
- [histogram](/products/haybarn/functions/releases/duckdb-1.5.5/histogram/index.md): Returns a LIST of STRUCTs with the fields bucket and count.
- [histogram_exact](/products/haybarn/functions/releases/duckdb-1.5.5/histogram_exact/index.md): Returns a LIST of STRUCTs with the fields bucket and count matching the buckets exactly.
- [histogram_values](/products/haybarn/functions/releases/duckdb-1.5.5/histogram_values/index.md): No description supplied.
- [hour](/products/haybarn/functions/releases/duckdb-1.5.5/hour/index.md): Extract the hour component from a date or timestamp
- [icu_calendar_names](/products/haybarn/functions/releases/duckdb-1.5.5/icu_calendar_names/index.md): No description supplied.
- [icu_collate_af](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_af/index.md): No description supplied.
- [icu_collate_am](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_am/index.md): No description supplied.
- [icu_collate_ar](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_ar/index.md): No description supplied.
- [icu_collate_ar_sa](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_ar_sa/index.md): No description supplied.
- [icu_collate_as](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_as/index.md): No description supplied.
- [icu_collate_az](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_az/index.md): No description supplied.
- [icu_collate_be](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_be/index.md): No description supplied.
- [icu_collate_bg](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_bg/index.md): No description supplied.
- [icu_collate_bn](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_bn/index.md): No description supplied.
- [icu_collate_bo](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_bo/index.md): No description supplied.
- [icu_collate_br](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_br/index.md): No description supplied.
- [icu_collate_bs](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_bs/index.md): No description supplied.
- [icu_collate_ca](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_ca/index.md): No description supplied.
- [icu_collate_ceb](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_ceb/index.md): No description supplied.
- [icu_collate_chr](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_chr/index.md): No description supplied.
- [icu_collate_cs](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_cs/index.md): No description supplied.
- [icu_collate_cy](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_cy/index.md): No description supplied.
- [icu_collate_da](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_da/index.md): No description supplied.
- [icu_collate_de](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_de/index.md): No description supplied.
- [icu_collate_de_at](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_de_at/index.md): No description supplied.
- [icu_collate_dsb](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_dsb/index.md): No description supplied.
- [icu_collate_dz](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_dz/index.md): No description supplied.
- [icu_collate_ee](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_ee/index.md): No description supplied.
- [icu_collate_el](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_el/index.md): No description supplied.
- [icu_collate_en](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_en/index.md): No description supplied.
- [icu_collate_en_us](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_en_us/index.md): No description supplied.
- [icu_collate_eo](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_eo/index.md): No description supplied.
- [icu_collate_es](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_es/index.md): No description supplied.
- [icu_collate_et](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_et/index.md): No description supplied.
- [icu_collate_fa](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_fa/index.md): No description supplied.
- [icu_collate_fa_af](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_fa_af/index.md): No description supplied.
- [icu_collate_ff](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_ff/index.md): No description supplied.
- [icu_collate_fi](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_fi/index.md): No description supplied.
- [icu_collate_fil](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_fil/index.md): No description supplied.
- [icu_collate_fo](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_fo/index.md): No description supplied.
- [icu_collate_fr](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_fr/index.md): No description supplied.
- [icu_collate_fr_ca](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_fr_ca/index.md): No description supplied.
- [icu_collate_fy](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_fy/index.md): No description supplied.
- [icu_collate_ga](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_ga/index.md): No description supplied.
- [icu_collate_gl](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_gl/index.md): No description supplied.
- [icu_collate_gu](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_gu/index.md): No description supplied.
- [icu_collate_ha](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_ha/index.md): No description supplied.
- [icu_collate_haw](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_haw/index.md): No description supplied.
- [icu_collate_he](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_he/index.md): No description supplied.
- [icu_collate_he_il](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_he_il/index.md): No description supplied.
- [icu_collate_hi](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_hi/index.md): No description supplied.
- [icu_collate_hr](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_hr/index.md): No description supplied.
- [icu_collate_hsb](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_hsb/index.md): No description supplied.
- [icu_collate_hu](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_hu/index.md): No description supplied.
- [icu_collate_hy](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_hy/index.md): No description supplied.
- [icu_collate_id](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_id/index.md): No description supplied.
- [icu_collate_id_id](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_id_id/index.md): No description supplied.
- [icu_collate_ig](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_ig/index.md): No description supplied.
- [icu_collate_is](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_is/index.md): No description supplied.
- [icu_collate_it](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_it/index.md): No description supplied.
- [icu_collate_ja](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_ja/index.md): No description supplied.
- [icu_collate_ka](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_ka/index.md): No description supplied.
- [icu_collate_kk](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_kk/index.md): No description supplied.
- [icu_collate_kl](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_kl/index.md): No description supplied.
- [icu_collate_km](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_km/index.md): No description supplied.
- [icu_collate_kn](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_kn/index.md): No description supplied.
- [icu_collate_ko](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_ko/index.md): No description supplied.
- [icu_collate_kok](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_kok/index.md): No description supplied.
- [icu_collate_ku](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_ku/index.md): No description supplied.
- [icu_collate_ky](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_ky/index.md): No description supplied.
- [icu_collate_lb](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_lb/index.md): No description supplied.
- [icu_collate_lij](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_lij/index.md): No description supplied.
- [icu_collate_lkt](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_lkt/index.md): No description supplied.
- [icu_collate_ln](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_ln/index.md): No description supplied.
- [icu_collate_lo](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_lo/index.md): No description supplied.
- [icu_collate_lt](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_lt/index.md): No description supplied.
- [icu_collate_lv](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_lv/index.md): No description supplied.
- [icu_collate_mk](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_mk/index.md): No description supplied.
- [icu_collate_ml](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_ml/index.md): No description supplied.
- [icu_collate_mn](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_mn/index.md): No description supplied.
- [icu_collate_mr](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_mr/index.md): No description supplied.
- [icu_collate_ms](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_ms/index.md): No description supplied.
- [icu_collate_mt](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_mt/index.md): No description supplied.
- [icu_collate_my](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_my/index.md): No description supplied.
- [icu_collate_nb](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_nb/index.md): No description supplied.
- [icu_collate_nb_no](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_nb_no/index.md): No description supplied.
- [icu_collate_ne](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_ne/index.md): No description supplied.
- [icu_collate_nl](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_nl/index.md): No description supplied.
- [icu_collate_nn](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_nn/index.md): No description supplied.
- [icu_collate_noaccent](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_noaccent/index.md): No description supplied.
- [icu_collate_nso](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_nso/index.md): No description supplied.
- [icu_collate_om](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_om/index.md): No description supplied.
- [icu_collate_or](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_or/index.md): No description supplied.
- [icu_collate_pa](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_pa/index.md): No description supplied.
- [icu_collate_pa_in](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_pa_in/index.md): No description supplied.
- [icu_collate_pl](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_pl/index.md): No description supplied.
- [icu_collate_ps](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_ps/index.md): No description supplied.
- [icu_collate_pt](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_pt/index.md): No description supplied.
- [icu_collate_ro](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_ro/index.md): No description supplied.
- [icu_collate_ru](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_ru/index.md): No description supplied.
- [icu_collate_sa](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_sa/index.md): No description supplied.
- [icu_collate_se](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_se/index.md): No description supplied.
- [icu_collate_si](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_si/index.md): No description supplied.
- [icu_collate_sk](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_sk/index.md): No description supplied.
- [icu_collate_sl](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_sl/index.md): No description supplied.
- [icu_collate_smn](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_smn/index.md): No description supplied.
- [icu_collate_sq](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_sq/index.md): No description supplied.
- [icu_collate_sr](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_sr/index.md): No description supplied.
- [icu_collate_sr_ba](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_sr_ba/index.md): No description supplied.
- [icu_collate_sr_me](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_sr_me/index.md): No description supplied.
- [icu_collate_sr_rs](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_sr_rs/index.md): No description supplied.
- [icu_collate_st](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_st/index.md): No description supplied.
- [icu_collate_sv](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_sv/index.md): No description supplied.
- [icu_collate_sw](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_sw/index.md): No description supplied.
- [icu_collate_ta](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_ta/index.md): No description supplied.
- [icu_collate_te](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_te/index.md): No description supplied.
- [icu_collate_th](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_th/index.md): No description supplied.
- [icu_collate_tk](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_tk/index.md): No description supplied.
- [icu_collate_tn](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_tn/index.md): No description supplied.
- [icu_collate_to](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_to/index.md): No description supplied.
- [icu_collate_tr](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_tr/index.md): No description supplied.
- [icu_collate_ug](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_ug/index.md): No description supplied.
- [icu_collate_uk](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_uk/index.md): No description supplied.
- [icu_collate_ur](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_ur/index.md): No description supplied.
- [icu_collate_uz](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_uz/index.md): No description supplied.
- [icu_collate_vi](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_vi/index.md): No description supplied.
- [icu_collate_wae](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_wae/index.md): No description supplied.
- [icu_collate_wo](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_wo/index.md): No description supplied.
- [icu_collate_xh](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_xh/index.md): No description supplied.
- [icu_collate_yi](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_yi/index.md): No description supplied.
- [icu_collate_yo](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_yo/index.md): No description supplied.
- [icu_collate_yue](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_yue/index.md): No description supplied.
- [icu_collate_yue_cn](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_yue_cn/index.md): No description supplied.
- [icu_collate_zh](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_zh/index.md): No description supplied.
- [icu_collate_zh_cn](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_zh_cn/index.md): No description supplied.
- [icu_collate_zh_hk](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_zh_hk/index.md): No description supplied.
- [icu_collate_zh_mo](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_zh_mo/index.md): No description supplied.
- [icu_collate_zh_sg](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_zh_sg/index.md): No description supplied.
- [icu_collate_zh_tw](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_zh_tw/index.md): No description supplied.
- [icu_collate_zu](/products/haybarn/functions/releases/duckdb-1.5.5/icu_collate_zu/index.md): No description supplied.
- [icu_sort_key](/products/haybarn/functions/releases/duckdb-1.5.5/icu_sort_key/index.md): No description supplied.
- [ilike_escape](/products/haybarn/functions/releases/duckdb-1.5.5/ilike_escape/index.md): Returns `true` if the `string` matches the `like_specifier` (see Pattern Matching) using case-insensitive matching. `escape_character` is used to search for wildcard characters in the `string`.
- [import_database](/products/haybarn/functions/releases/duckdb-1.5.5/import_database/index.md): No description supplied.
- [in_search_path](/products/haybarn/functions/releases/duckdb-1.5.5/in_search_path/index.md): Returns whether or not the database/schema are in the search path
- [instr](/products/haybarn/functions/releases/duckdb-1.5.5/instr/index.md): Returns location of first occurrence of `search_string` in `string`, counting from 1. Returns 0 if no match found.
- [is_histogram_other_bin](/products/haybarn/functions/releases/duckdb-1.5.5/is_histogram_other_bin/index.md): Whether or not the provided value is the histogram "other" bin (used for values not belonging to any provided bin)
- [isfinite](/products/haybarn/functions/releases/duckdb-1.5.5/isfinite/index.md): Returns true if the floating point value is finite, false otherwise
- [isinf](/products/haybarn/functions/releases/duckdb-1.5.5/isinf/index.md): Returns true if the floating point value is infinite, false otherwise
- [isnan](/products/haybarn/functions/releases/duckdb-1.5.5/isnan/index.md): Returns true if the floating point value is not a number, false otherwise
- [isodow](/products/haybarn/functions/releases/duckdb-1.5.5/isodow/index.md): Extract the isodow component from a date or timestamp
- [isoyear](/products/haybarn/functions/releases/duckdb-1.5.5/isoyear/index.md): Extract the isoyear component from a date or timestamp
- [jaccard](/products/haybarn/functions/releases/duckdb-1.5.5/jaccard/index.md): The Jaccard similarity between two strings. Characters of different cases (e.g., `a` and `A`) are considered different. Returns a number between 0 and 1.
- [jaro_similarity](/products/haybarn/functions/releases/duckdb-1.5.5/jaro_similarity/index.md): The Jaro similarity between two strings. Characters of different cases (e.g., `a` and `A`) are considered different. Returns a number between 0 and 1. For similarity < `score_cutoff`, 0 is returned instead. `score_cutoff` defaults to 0.
- [jaro_winkler_similarity](/products/haybarn/functions/releases/duckdb-1.5.5/jaro_winkler_similarity/index.md): The Jaro-Winkler similarity between two strings. Characters of different cases (e.g., `a` and `A`) are considered different. Returns a number between 0 and 1. For similarity < `score_cutoff`, 0 is returned instead. `score_cutoff` defaults to 0.
- [json](/products/haybarn/functions/releases/duckdb-1.5.5/json/index.md): No description supplied.
- [json_array](/products/haybarn/functions/releases/duckdb-1.5.5/json_array/index.md): No description supplied.
- [json_array_length](/products/haybarn/functions/releases/duckdb-1.5.5/json_array_length/index.md): No description supplied.
- [json_contains](/products/haybarn/functions/releases/duckdb-1.5.5/json_contains/index.md): No description supplied.
- [json_deserialize_sql](/products/haybarn/functions/releases/duckdb-1.5.5/json_deserialize_sql/index.md): No description supplied.
- [json_each](/products/haybarn/functions/releases/duckdb-1.5.5/json_each/index.md): No description supplied.
- [json_execute_serialized_sql](/products/haybarn/functions/releases/duckdb-1.5.5/json_execute_serialized_sql/index.md): No description supplied.
- [json_exists](/products/haybarn/functions/releases/duckdb-1.5.5/json_exists/index.md): No description supplied.
- [json_extract](/products/haybarn/functions/releases/duckdb-1.5.5/json_extract/index.md): No description supplied.
- [json_extract_path](/products/haybarn/functions/releases/duckdb-1.5.5/json_extract_path/index.md): No description supplied.
- [json_extract_path_text](/products/haybarn/functions/releases/duckdb-1.5.5/json_extract_path_text/index.md): No description supplied.
- [json_extract_string](/products/haybarn/functions/releases/duckdb-1.5.5/json_extract_string/index.md): No description supplied.
- [json_group_array](/products/haybarn/functions/releases/duckdb-1.5.5/json_group_array/index.md): No description supplied.
- [json_group_object](/products/haybarn/functions/releases/duckdb-1.5.5/json_group_object/index.md): No description supplied.
- [json_group_structure](/products/haybarn/functions/releases/duckdb-1.5.5/json_group_structure/index.md): No description supplied.
- [json_keys](/products/haybarn/functions/releases/duckdb-1.5.5/json_keys/index.md): No description supplied.
- [json_merge_patch](/products/haybarn/functions/releases/duckdb-1.5.5/json_merge_patch/index.md): No description supplied.
- [json_object](/products/haybarn/functions/releases/duckdb-1.5.5/json_object/index.md): No description supplied.
- [json_pretty](/products/haybarn/functions/releases/duckdb-1.5.5/json_pretty/index.md): No description supplied.
- [json_quote](/products/haybarn/functions/releases/duckdb-1.5.5/json_quote/index.md): No description supplied.
- [json_serialize_plan](/products/haybarn/functions/releases/duckdb-1.5.5/json_serialize_plan/index.md): No description supplied.
- [json_serialize_sql](/products/haybarn/functions/releases/duckdb-1.5.5/json_serialize_sql/index.md): No description supplied.
- [json_structure](/products/haybarn/functions/releases/duckdb-1.5.5/json_structure/index.md): No description supplied.
- [json_transform](/products/haybarn/functions/releases/duckdb-1.5.5/json_transform/index.md): No description supplied.
- [json_transform_strict](/products/haybarn/functions/releases/duckdb-1.5.5/json_transform_strict/index.md): No description supplied.
- [json_tree](/products/haybarn/functions/releases/duckdb-1.5.5/json_tree/index.md): No description supplied.
- [json_type](/products/haybarn/functions/releases/duckdb-1.5.5/json_type/index.md): No description supplied.
- [json_valid](/products/haybarn/functions/releases/duckdb-1.5.5/json_valid/index.md): No description supplied.
- [json_value](/products/haybarn/functions/releases/duckdb-1.5.5/json_value/index.md): No description supplied.
- [julian](/products/haybarn/functions/releases/duckdb-1.5.5/julian/index.md): Extract the Julian Day number from a date or timestamp
- [kahan_sum](/products/haybarn/functions/releases/duckdb-1.5.5/kahan_sum/index.md): Calculates the sum using a more accurate floating point summation (Kahan Sum).
- [kurtosis](/products/haybarn/functions/releases/duckdb-1.5.5/kurtosis/index.md): Returns the excess kurtosis (Fisher’s definition) of all input values, with a bias correction according to the sample size
- [kurtosis_pop](/products/haybarn/functions/releases/duckdb-1.5.5/kurtosis_pop/index.md): Returns the excess kurtosis (Fisher’s definition) of all input values, without bias correction
- [lag](/products/haybarn/functions/releases/duckdb-1.5.5/lag/index.md): No description supplied.
- [last](/products/haybarn/functions/releases/duckdb-1.5.5/last/index.md): Returns the last value of a column. This function is affected by ordering.
- [last_day](/products/haybarn/functions/releases/duckdb-1.5.5/last_day/index.md): Returns the last day of the month
- [last_value](/products/haybarn/functions/releases/duckdb-1.5.5/last_value/index.md): No description supplied.
- [lcase](/products/haybarn/functions/releases/duckdb-1.5.5/lcase/index.md): Converts `string` to lower case.
- [lcm](/products/haybarn/functions/releases/duckdb-1.5.5/lcm/index.md): Computes the least common multiple of x and y
- [lead](/products/haybarn/functions/releases/duckdb-1.5.5/lead/index.md): No description supplied.
- [least](/products/haybarn/functions/releases/duckdb-1.5.5/least/index.md): Returns the smallest value. For strings lexicographical ordering is used. Note that uppercase characters are considered “smaller” than lowercase characters, and collations are not supported.
- [least_common_multiple](/products/haybarn/functions/releases/duckdb-1.5.5/least_common_multiple/index.md): Computes the least common multiple of x and y
- [left](/products/haybarn/functions/releases/duckdb-1.5.5/left/index.md): Extracts the left-most count characters.
- [left_grapheme](/products/haybarn/functions/releases/duckdb-1.5.5/left_grapheme/index.md): Extracts the left-most count grapheme clusters.
- [len](/products/haybarn/functions/releases/duckdb-1.5.5/len/index.md): Returns the bit-length of the `bit` argument.
- [length](/products/haybarn/functions/releases/duckdb-1.5.5/length/index.md): Returns the bit-length of the `bit` argument.
- [length_grapheme](/products/haybarn/functions/releases/duckdb-1.5.5/length_grapheme/index.md): Number of grapheme clusters in `string`.
- [levenshtein](/products/haybarn/functions/releases/duckdb-1.5.5/levenshtein/index.md): The minimum number of single-character edits (insertions, deletions or substitutions) required to change one string to the other. Characters of different cases (e.g., `a` and `A`) are considered different.
- [lgamma](/products/haybarn/functions/releases/duckdb-1.5.5/lgamma/index.md): Computes the log of the gamma function
- [like_escape](/products/haybarn/functions/releases/duckdb-1.5.5/like_escape/index.md): Returns `true` if the `string` matches the `like_specifier` (see Pattern Matching) using case-sensitive matching. `escape_character` is used to search for wildcard characters in the `string`.
- [list](/products/haybarn/functions/releases/duckdb-1.5.5/list/index.md): Returns a LIST containing all the values of a column.
- [list_aggr](/products/haybarn/functions/releases/duckdb-1.5.5/list_aggr/index.md): Executes the aggregate function `function_name` on the elements of `list`.
- [list_aggregate](/products/haybarn/functions/releases/duckdb-1.5.5/list_aggregate/index.md): Executes the aggregate function `function_name` on the elements of `list`.
- [list_any_value](/products/haybarn/functions/releases/duckdb-1.5.5/list_any_value/index.md): No description supplied.
- [list_append](/products/haybarn/functions/releases/duckdb-1.5.5/list_append/index.md): No description supplied.
- [list_apply](/products/haybarn/functions/releases/duckdb-1.5.5/list_apply/index.md): Returns a list that is the result of applying the `lambda` function to each element of the input `list`. The return type is defined by the return type of the `lambda` function.
- [list_approx_count_distinct](/products/haybarn/functions/releases/duckdb-1.5.5/list_approx_count_distinct/index.md): No description supplied.
- [list_avg](/products/haybarn/functions/releases/duckdb-1.5.5/list_avg/index.md): No description supplied.
- [list_bit_and](/products/haybarn/functions/releases/duckdb-1.5.5/list_bit_and/index.md): No description supplied.
- [list_bit_or](/products/haybarn/functions/releases/duckdb-1.5.5/list_bit_or/index.md): No description supplied.
- [list_bit_xor](/products/haybarn/functions/releases/duckdb-1.5.5/list_bit_xor/index.md): No description supplied.
- [list_bool_and](/products/haybarn/functions/releases/duckdb-1.5.5/list_bool_and/index.md): No description supplied.
- [list_bool_or](/products/haybarn/functions/releases/duckdb-1.5.5/list_bool_or/index.md): No description supplied.
- [list_cat](/products/haybarn/functions/releases/duckdb-1.5.5/list_cat/index.md): Concatenates lists. `NULL` inputs are skipped. See also operator `||`.
- [list_concat](/products/haybarn/functions/releases/duckdb-1.5.5/list_concat/index.md): Concatenates lists. `NULL` inputs are skipped. See also operator `||`.
- [list_contains](/products/haybarn/functions/releases/duckdb-1.5.5/list_contains/index.md): Returns true if the list contains the element.
- [list_cosine_distance](/products/haybarn/functions/releases/duckdb-1.5.5/list_cosine_distance/index.md): Computes the cosine distance between two same-sized lists.
- [list_cosine_similarity](/products/haybarn/functions/releases/duckdb-1.5.5/list_cosine_similarity/index.md): Computes the cosine similarity between two same-sized lists.
- [list_count](/products/haybarn/functions/releases/duckdb-1.5.5/list_count/index.md): No description supplied.
- [list_distance](/products/haybarn/functions/releases/duckdb-1.5.5/list_distance/index.md): Calculates the Euclidean distance between two points with coordinates given in two inputs lists of equal length.
- [list_distinct](/products/haybarn/functions/releases/duckdb-1.5.5/list_distinct/index.md): Removes all duplicates and `NULL` values from a list. Does not preserve the original order.
- [list_dot_product](/products/haybarn/functions/releases/duckdb-1.5.5/list_dot_product/index.md): Computes the inner product between two same-sized lists.
- [list_element](/products/haybarn/functions/releases/duckdb-1.5.5/list_element/index.md): Extract the `index`th (1-based) value from the list.
- [list_entropy](/products/haybarn/functions/releases/duckdb-1.5.5/list_entropy/index.md): No description supplied.
- [list_extract](/products/haybarn/functions/releases/duckdb-1.5.5/list_extract/index.md): Extract the `index`th (1-based) value from the list.
- [list_filter](/products/haybarn/functions/releases/duckdb-1.5.5/list_filter/index.md): Constructs a list from those elements of the input `list` for which the `lambda` function returns `true`. DuckDB must be able to cast the `lambda` function's return type to `BOOL`. The return type of `list_filter` is the same as the input list's.
- [list_first](/products/haybarn/functions/releases/duckdb-1.5.5/list_first/index.md): No description supplied.
- [list_grade_up](/products/haybarn/functions/releases/duckdb-1.5.5/list_grade_up/index.md): Works like list_sort, but the results are the indexes that correspond to the position in the original list instead of the actual values.
- [list_has](/products/haybarn/functions/releases/duckdb-1.5.5/list_has/index.md): Returns true if the list contains the element.
- [list_has_all](/products/haybarn/functions/releases/duckdb-1.5.5/list_has_all/index.md): Returns true if all elements of list2 are in list1. NULLs are ignored.
- [list_has_any](/products/haybarn/functions/releases/duckdb-1.5.5/list_has_any/index.md): Returns true if the lists have any element in common. NULLs are ignored.
- [list_histogram](/products/haybarn/functions/releases/duckdb-1.5.5/list_histogram/index.md): No description supplied.
- [list_indexof](/products/haybarn/functions/releases/duckdb-1.5.5/list_indexof/index.md): Returns the index of the `element` if the `list` contains the `element`. If the `element` is not found, it returns `NULL`.
- [list_inner_product](/products/haybarn/functions/releases/duckdb-1.5.5/list_inner_product/index.md): Computes the inner product between two same-sized lists.
- [list_intersect](/products/haybarn/functions/releases/duckdb-1.5.5/list_intersect/index.md): Returns a list containing the distinct elements that are present in both `list1` and `list2`.
- [list_kurtosis](/products/haybarn/functions/releases/duckdb-1.5.5/list_kurtosis/index.md): No description supplied.
- [list_kurtosis_pop](/products/haybarn/functions/releases/duckdb-1.5.5/list_kurtosis_pop/index.md): No description supplied.
- [list_last](/products/haybarn/functions/releases/duckdb-1.5.5/list_last/index.md): No description supplied.
- [list_mad](/products/haybarn/functions/releases/duckdb-1.5.5/list_mad/index.md): No description supplied.
- [list_max](/products/haybarn/functions/releases/duckdb-1.5.5/list_max/index.md): No description supplied.
- [list_median](/products/haybarn/functions/releases/duckdb-1.5.5/list_median/index.md): No description supplied.
- [list_min](/products/haybarn/functions/releases/duckdb-1.5.5/list_min/index.md): No description supplied.
- [list_mode](/products/haybarn/functions/releases/duckdb-1.5.5/list_mode/index.md): No description supplied.
- [list_negative_dot_product](/products/haybarn/functions/releases/duckdb-1.5.5/list_negative_dot_product/index.md): Computes the negative inner product between two same-sized lists.
- [list_negative_inner_product](/products/haybarn/functions/releases/duckdb-1.5.5/list_negative_inner_product/index.md): Computes the negative inner product between two same-sized lists.
- [list_pack](/products/haybarn/functions/releases/duckdb-1.5.5/list_pack/index.md): Creates a LIST containing the argument values.
- [list_position](/products/haybarn/functions/releases/duckdb-1.5.5/list_position/index.md): Returns the index of the `element` if the `list` contains the `element`. If the `element` is not found, it returns `NULL`.
- [list_prepend](/products/haybarn/functions/releases/duckdb-1.5.5/list_prepend/index.md): No description supplied.
- [list_product](/products/haybarn/functions/releases/duckdb-1.5.5/list_product/index.md): No description supplied.
- [list_reduce](/products/haybarn/functions/releases/duckdb-1.5.5/list_reduce/index.md): Reduces all elements of the input `list` into a single scalar value by executing the `lambda` function on a running result and the next list element. The `lambda` function has an optional `initial_value` argument.
- [list_resize](/products/haybarn/functions/releases/duckdb-1.5.5/list_resize/index.md): Resizes the `list` to contain `size` elements. Initializes new elements with `value` or `NULL` if `value` is not set.
- [list_reverse](/products/haybarn/functions/releases/duckdb-1.5.5/list_reverse/index.md): No description supplied.
- [list_reverse_sort](/products/haybarn/functions/releases/duckdb-1.5.5/list_reverse_sort/index.md): Sorts the elements of the list in reverse order.
- [list_select](/products/haybarn/functions/releases/duckdb-1.5.5/list_select/index.md): Returns a list based on the elements selected by the `index_list`.
- [list_sem](/products/haybarn/functions/releases/duckdb-1.5.5/list_sem/index.md): No description supplied.
- [list_skewness](/products/haybarn/functions/releases/duckdb-1.5.5/list_skewness/index.md): No description supplied.
- [list_slice](/products/haybarn/functions/releases/duckdb-1.5.5/list_slice/index.md): list_slice with added step feature.
- [list_sort](/products/haybarn/functions/releases/duckdb-1.5.5/list_sort/index.md): Sorts the elements of the list.
- [list_stddev_pop](/products/haybarn/functions/releases/duckdb-1.5.5/list_stddev_pop/index.md): No description supplied.
- [list_stddev_samp](/products/haybarn/functions/releases/duckdb-1.5.5/list_stddev_samp/index.md): No description supplied.
- [list_string_agg](/products/haybarn/functions/releases/duckdb-1.5.5/list_string_agg/index.md): No description supplied.
- [list_sum](/products/haybarn/functions/releases/duckdb-1.5.5/list_sum/index.md): No description supplied.
- [list_transform](/products/haybarn/functions/releases/duckdb-1.5.5/list_transform/index.md): Returns a list that is the result of applying the `lambda` function to each element of the input `list`. The return type is defined by the return type of the `lambda` function.
- [list_unique](/products/haybarn/functions/releases/duckdb-1.5.5/list_unique/index.md): Counts the unique elements of a `list`.
- [list_value](/products/haybarn/functions/releases/duckdb-1.5.5/list_value/index.md): Creates a LIST containing the argument values.
- [list_var_pop](/products/haybarn/functions/releases/duckdb-1.5.5/list_var_pop/index.md): No description supplied.
- [list_var_samp](/products/haybarn/functions/releases/duckdb-1.5.5/list_var_samp/index.md): No description supplied.
- [list_where](/products/haybarn/functions/releases/duckdb-1.5.5/list_where/index.md): Returns a list with the `BOOLEAN`s in `mask_list` applied as a mask to the `value_list`.
- [list_zip](/products/haybarn/functions/releases/duckdb-1.5.5/list_zip/index.md): Zips n `LIST`s to a new `LIST` whose length will be that of the longest list. Its elements are structs of n elements from each list `list_1`, …, `list_n`, missing elements are replaced with `NULL`. If `truncate` is set, all lists are truncated to the smallest list length.
- [listagg](/products/haybarn/functions/releases/duckdb-1.5.5/listagg/index.md): Concatenates the column string values with an optional separator.
- [ln](/products/haybarn/functions/releases/duckdb-1.5.5/ln/index.md): Computes the natural logarithm of x
- [log](/products/haybarn/functions/releases/duckdb-1.5.5/log/index.md): Computes the logarithm of x to base b. b may be omitted, in which case the default 10
- [log10](/products/haybarn/functions/releases/duckdb-1.5.5/log10/index.md): Computes the 10-log of x
- [log2](/products/haybarn/functions/releases/duckdb-1.5.5/log2/index.md): Computes the 2-log of x
- [lower](/products/haybarn/functions/releases/duckdb-1.5.5/lower/index.md): Converts `string` to lower case.
- [lpad](/products/haybarn/functions/releases/duckdb-1.5.5/lpad/index.md): Pads the `string` with the `character` on the left until it has `count` characters. Truncates the `string` on the right if it has more than `count` characters.
- [ltrim](/products/haybarn/functions/releases/duckdb-1.5.5/ltrim/index.md): Removes any occurrences of any of the `characters` from the left side of the `string`. `characters` defaults to `space`.
- [mad](/products/haybarn/functions/releases/duckdb-1.5.5/mad/index.md): Returns the median absolute deviation for the values within x. NULL values are ignored. Temporal types return a positive INTERVAL. 
- [make_date](/products/haybarn/functions/releases/duckdb-1.5.5/make_date/index.md): The date for the given struct.
- [make_time](/products/haybarn/functions/releases/duckdb-1.5.5/make_time/index.md): The time for the given parts
- [make_timestamp](/products/haybarn/functions/releases/duckdb-1.5.5/make_timestamp/index.md): The timestamp for the given parts
- [make_timestamp_ms](/products/haybarn/functions/releases/duckdb-1.5.5/make_timestamp_ms/index.md): The timestamp for the given microseconds since the epoch
- [make_timestamp_ns](/products/haybarn/functions/releases/duckdb-1.5.5/make_timestamp_ns/index.md): The timestamp for the given nanoseconds since epoch
- [make_timestamptz](/products/haybarn/functions/releases/duckdb-1.5.5/make_timestamptz/index.md): No description supplied.
- [make_type](/products/haybarn/functions/releases/duckdb-1.5.5/make_type/index.md): Construct a type from its name and optional parameters
- [map](/products/haybarn/functions/releases/duckdb-1.5.5/map/index.md): Creates a map from a set of keys and values
- [map_concat](/products/haybarn/functions/releases/duckdb-1.5.5/map_concat/index.md): Returns a map created from merging the input maps, on key collision the value is taken from the last map with that key
- [map_contains](/products/haybarn/functions/releases/duckdb-1.5.5/map_contains/index.md): Checks if a map contains a given key.
- [map_contains_entry](/products/haybarn/functions/releases/duckdb-1.5.5/map_contains_entry/index.md): No description supplied.
- [map_contains_value](/products/haybarn/functions/releases/duckdb-1.5.5/map_contains_value/index.md): No description supplied.
- [map_entries](/products/haybarn/functions/releases/duckdb-1.5.5/map_entries/index.md): Returns the map entries as a list of keys/values
- [map_extract](/products/haybarn/functions/releases/duckdb-1.5.5/map_extract/index.md): Returns a list containing the value for a given key or an empty list if the key is not contained in the map. The type of the key provided in the second parameter must match the type of the map’s keys else an error is returned
- [map_extract_value](/products/haybarn/functions/releases/duckdb-1.5.5/map_extract_value/index.md): Returns the value for a given key or NULL if the key is not contained in the map. The type of the key provided in the second parameter must match the type of the map’s keys else an error is returned
- [map_from_entries](/products/haybarn/functions/releases/duckdb-1.5.5/map_from_entries/index.md): Returns a map created from the entries of the array
- [map_keys](/products/haybarn/functions/releases/duckdb-1.5.5/map_keys/index.md): Returns the keys of a map as a list
- [map_values](/products/haybarn/functions/releases/duckdb-1.5.5/map_values/index.md): Returns the values of a map as a list
- [max](/products/haybarn/functions/releases/duckdb-1.5.5/max/index.md): Returns the maximum value present in arg.
- [max_by](/products/haybarn/functions/releases/duckdb-1.5.5/max_by/index.md): Finds the row with the maximum val. Calculates the non-NULL arg expression at that row.
- [md5](/products/haybarn/functions/releases/duckdb-1.5.5/md5/index.md): Returns the MD5 hash of the `blob` as a `VARCHAR`.
- [md5_number](/products/haybarn/functions/releases/duckdb-1.5.5/md5_number/index.md): Returns the MD5 hash of the `blob` as a `HUGEINT`.
- [md5_number_lower](/products/haybarn/functions/releases/duckdb-1.5.5/md5_number_lower/index.md): No description supplied.
- [md5_number_upper](/products/haybarn/functions/releases/duckdb-1.5.5/md5_number_upper/index.md): No description supplied.
- [mean](/products/haybarn/functions/releases/duckdb-1.5.5/mean/index.md): Calculates the average value for all tuples in x.
- [median](/products/haybarn/functions/releases/duckdb-1.5.5/median/index.md): Returns the middle value of the set. NULL values are ignored. For even value counts, interpolate-able types (numeric, date/time) return the average of the two middle values. Non-interpolate-able types (everything else) return the lower of the two middle values.
- [metadata_info](/products/haybarn/functions/releases/duckdb-1.5.5/metadata_info/index.md): No description supplied.
- [microsecond](/products/haybarn/functions/releases/duckdb-1.5.5/microsecond/index.md): Extract the microsecond component from a date or timestamp
- [millennium](/products/haybarn/functions/releases/duckdb-1.5.5/millennium/index.md): Extract the millennium component from a date or timestamp
- [millisecond](/products/haybarn/functions/releases/duckdb-1.5.5/millisecond/index.md): Extract the millisecond component from a date or timestamp
- [min](/products/haybarn/functions/releases/duckdb-1.5.5/min/index.md): Returns the minimum value present in arg.
- [min_by](/products/haybarn/functions/releases/duckdb-1.5.5/min_by/index.md): Finds the row with the minimum val. Calculates the non-NULL arg expression at that row.
- [minute](/products/haybarn/functions/releases/duckdb-1.5.5/minute/index.md): Extract the minute component from a date or timestamp
- [mismatches](/products/haybarn/functions/releases/duckdb-1.5.5/mismatches/index.md): The Hamming distance between to strings, i.e., the number of positions with different characters for two strings of equal length. Strings must be of equal length. Characters of different cases (e.g., `a` and `A`) are considered different.
- [mod](/products/haybarn/functions/releases/duckdb-1.5.5/mod/index.md): No description supplied.
- [mode](/products/haybarn/functions/releases/duckdb-1.5.5/mode/index.md): Returns the most frequent value for the values within x. NULL values are ignored.
- [month](/products/haybarn/functions/releases/duckdb-1.5.5/month/index.md): Extract the month component from a date or timestamp
- [monthname](/products/haybarn/functions/releases/duckdb-1.5.5/monthname/index.md): The (English) name of the month
- [multiply](/products/haybarn/functions/releases/duckdb-1.5.5/multiply/index.md): No description supplied.
- [nanosecond](/products/haybarn/functions/releases/duckdb-1.5.5/nanosecond/index.md): Extract the nanosecond component from a date or timestamp
- [nextafter](/products/haybarn/functions/releases/duckdb-1.5.5/nextafter/index.md): Returns the next floating point value after x in the direction of y
- [nextval](/products/haybarn/functions/releases/duckdb-1.5.5/nextval/index.md): Return the following value of the sequence.
- [nfc_normalize](/products/haybarn/functions/releases/duckdb-1.5.5/nfc_normalize/index.md): Converts `string` to Unicode NFC normalized string. Useful for comparisons and ordering if text data is mixed between NFC normalized and not.
- [normalized_interval](/products/haybarn/functions/releases/duckdb-1.5.5/normalized_interval/index.md): Normalizes an INTERVAL to an equivalent interval
- [not_ilike_escape](/products/haybarn/functions/releases/duckdb-1.5.5/not_ilike_escape/index.md): Returns `false` if the `string` matches the `like_specifier` (see Pattern Matching) using case-insensitive matching. `escape_character` is used to search for wildcard characters in the `string`.
- [not_like_escape](/products/haybarn/functions/releases/duckdb-1.5.5/not_like_escape/index.md): Returns `false` if the `string` matches the `like_specifier` (see Pattern Matching) using case-sensitive matching. `escape_character` is used to search for wildcard characters in the `string`.
- [now](/products/haybarn/functions/releases/duckdb-1.5.5/now/index.md): Returns the current timestamp
- [nth_value](/products/haybarn/functions/releases/duckdb-1.5.5/nth_value/index.md): No description supplied.
- [ntile](/products/haybarn/functions/releases/duckdb-1.5.5/ntile/index.md): No description supplied.
- [nullif](/products/haybarn/functions/releases/duckdb-1.5.5/nullif/index.md): No description supplied.
- [octet_length](/products/haybarn/functions/releases/duckdb-1.5.5/octet_length/index.md): Returns the number of bytes in the `bitstring`.
- [ord](/products/haybarn/functions/releases/duckdb-1.5.5/ord/index.md): Returns an `INTEGER` representing the `unicode` codepoint of the first character in the `string`.
- [parquet_bloom_probe](/products/haybarn/functions/releases/duckdb-1.5.5/parquet_bloom_probe/index.md): No description supplied.
- [parquet_file_metadata](/products/haybarn/functions/releases/duckdb-1.5.5/parquet_file_metadata/index.md): No description supplied.
- [parquet_full_metadata](/products/haybarn/functions/releases/duckdb-1.5.5/parquet_full_metadata/index.md): No description supplied.
- [parquet_kv_metadata](/products/haybarn/functions/releases/duckdb-1.5.5/parquet_kv_metadata/index.md): No description supplied.
- [parquet_metadata](/products/haybarn/functions/releases/duckdb-1.5.5/parquet_metadata/index.md): No description supplied.
- [parquet_scan](/products/haybarn/functions/releases/duckdb-1.5.5/parquet_scan/index.md): No description supplied.
- [parquet_schema](/products/haybarn/functions/releases/duckdb-1.5.5/parquet_schema/index.md): No description supplied.
- [parse_dirname](/products/haybarn/functions/releases/duckdb-1.5.5/parse_dirname/index.md): Returns the top-level directory name from the given `path`. `separator` options: `system`, `both_slash` (default), `forward_slash`, `backslash`.
- [parse_dirpath](/products/haybarn/functions/releases/duckdb-1.5.5/parse_dirpath/index.md): Returns the head of the `path` (the pathname until the last slash) similarly to Python's `os.path.dirname`. `separator` options: `system`, `both_slash` (default), `forward_slash`, `backslash`.
- [parse_duckdb_log_message](/products/haybarn/functions/releases/duckdb-1.5.5/parse_duckdb_log_message/index.md): Parse the message into the expected logical type
- [parse_filename](/products/haybarn/functions/releases/duckdb-1.5.5/parse_filename/index.md): Returns the last component of the `path` similarly to Python's `os.path.basename` function. If `trim_extension` is `true`, the file extension will be removed (defaults to `false`). `separator` options: `system`, `both_slash` (default), `forward_slash`, `backslash`.
- [parse_formatted_bytes](/products/haybarn/functions/releases/duckdb-1.5.5/parse_formatted_bytes/index.md): Parses a human-readable representation of a size in bytes into an integer.
- [parse_path](/products/haybarn/functions/releases/duckdb-1.5.5/parse_path/index.md): Returns a list of the components (directories and filename) in the `path` similarly to Python's `pathlib.parts` function. `separator` options: `system`, `both_slash` (default), `forward_slash`, `backslash`.
- [percent_rank](/products/haybarn/functions/releases/duckdb-1.5.5/percent_rank/index.md): No description supplied.
- [pg_timezone_names](/products/haybarn/functions/releases/duckdb-1.5.5/pg_timezone_names/index.md): No description supplied.
- [pi](/products/haybarn/functions/releases/duckdb-1.5.5/pi/index.md): Returns the value of pi
- [platform](/products/haybarn/functions/releases/duckdb-1.5.5/platform/index.md): No description supplied.
- [position](/products/haybarn/functions/releases/duckdb-1.5.5/position/index.md): Returns location of first occurrence of `search_string` in `string`, counting from 1. Returns 0 if no match found.
- [pow](/products/haybarn/functions/releases/duckdb-1.5.5/pow/index.md): Computes x to the power of y
- [power](/products/haybarn/functions/releases/duckdb-1.5.5/power/index.md): Computes x to the power of y
- [pragma_collations](/products/haybarn/functions/releases/duckdb-1.5.5/pragma_collations/index.md): No description supplied.
- [pragma_database_size](/products/haybarn/functions/releases/duckdb-1.5.5/pragma_database_size/index.md): No description supplied.
- [pragma_metadata_info](/products/haybarn/functions/releases/duckdb-1.5.5/pragma_metadata_info/index.md): No description supplied.
- [pragma_platform](/products/haybarn/functions/releases/duckdb-1.5.5/pragma_platform/index.md): No description supplied.
- [pragma_show](/products/haybarn/functions/releases/duckdb-1.5.5/pragma_show/index.md): No description supplied.
- [pragma_storage_info](/products/haybarn/functions/releases/duckdb-1.5.5/pragma_storage_info/index.md): No description supplied.
- [pragma_table_info](/products/haybarn/functions/releases/duckdb-1.5.5/pragma_table_info/index.md): No description supplied.
- [pragma_user_agent](/products/haybarn/functions/releases/duckdb-1.5.5/pragma_user_agent/index.md): No description supplied.
- [pragma_version](/products/haybarn/functions/releases/duckdb-1.5.5/pragma_version/index.md): No description supplied.
- [prefix](/products/haybarn/functions/releases/duckdb-1.5.5/prefix/index.md): Returns `true` if `string` starts with `search_string`.
- [printf](/products/haybarn/functions/releases/duckdb-1.5.5/printf/index.md): Formats a `string` using printf syntax.
- [product](/products/haybarn/functions/releases/duckdb-1.5.5/product/index.md): Calculates the product of all tuples in arg.
- [quantile](/products/haybarn/functions/releases/duckdb-1.5.5/quantile/index.md): Returns the exact quantile number between 0 and 1 . If pos is a LIST of FLOATs, then the result is a LIST of the corresponding exact quantiles.
- [quantile_cont](/products/haybarn/functions/releases/duckdb-1.5.5/quantile_cont/index.md): Returns the interpolated quantile number between 0 and 1 . If pos is a LIST of FLOATs, then the result is a LIST of the corresponding interpolated quantiles. 
- [quantile_disc](/products/haybarn/functions/releases/duckdb-1.5.5/quantile_disc/index.md): Returns the exact quantile number between 0 and 1 . If pos is a LIST of FLOATs, then the result is a LIST of the corresponding exact quantiles.
- [quarter](/products/haybarn/functions/releases/duckdb-1.5.5/quarter/index.md): Extract the quarter component from a date or timestamp
- [query](/products/haybarn/functions/releases/duckdb-1.5.5/query/index.md): No description supplied.
- [query_table](/products/haybarn/functions/releases/duckdb-1.5.5/query_table/index.md): No description supplied.
- [radians](/products/haybarn/functions/releases/duckdb-1.5.5/radians/index.md): Converts degrees to radians
- [random](/products/haybarn/functions/releases/duckdb-1.5.5/random/index.md): Returns a random number between 0 and 1
- [range](/products/haybarn/functions/releases/duckdb-1.5.5/range/index.md): Creates a list of values between `start` and `stop` - the stop parameter is exclusive.
- [rank](/products/haybarn/functions/releases/duckdb-1.5.5/rank/index.md): No description supplied.
- [rank_dense](/products/haybarn/functions/releases/duckdb-1.5.5/rank_dense/index.md): No description supplied.
- [read_blob](/products/haybarn/functions/releases/duckdb-1.5.5/read_blob/index.md): No description supplied.
- [read_csv](/products/haybarn/functions/releases/duckdb-1.5.5/read_csv/index.md): No description supplied.
- [read_csv_auto](/products/haybarn/functions/releases/duckdb-1.5.5/read_csv_auto/index.md): No description supplied.
- [read_duckdb](/products/haybarn/functions/releases/duckdb-1.5.5/read_duckdb/index.md): No description supplied.
- [read_json](/products/haybarn/functions/releases/duckdb-1.5.5/read_json/index.md): No description supplied.
- [read_json_auto](/products/haybarn/functions/releases/duckdb-1.5.5/read_json_auto/index.md): No description supplied.
- [read_json_objects](/products/haybarn/functions/releases/duckdb-1.5.5/read_json_objects/index.md): No description supplied.
- [read_json_objects_auto](/products/haybarn/functions/releases/duckdb-1.5.5/read_json_objects_auto/index.md): No description supplied.
- [read_ndjson](/products/haybarn/functions/releases/duckdb-1.5.5/read_ndjson/index.md): No description supplied.
- [read_ndjson_auto](/products/haybarn/functions/releases/duckdb-1.5.5/read_ndjson_auto/index.md): No description supplied.
- [read_ndjson_objects](/products/haybarn/functions/releases/duckdb-1.5.5/read_ndjson_objects/index.md): No description supplied.
- [read_parquet](/products/haybarn/functions/releases/duckdb-1.5.5/read_parquet/index.md): No description supplied.
- [read_text](/products/haybarn/functions/releases/duckdb-1.5.5/read_text/index.md): No description supplied.
- [reduce](/products/haybarn/functions/releases/duckdb-1.5.5/reduce/index.md): Reduces all elements of the input `list` into a single scalar value by executing the `lambda` function on a running result and the next list element. The `lambda` function has an optional `initial_value` argument.
- [regexp_escape](/products/haybarn/functions/releases/duckdb-1.5.5/regexp_escape/index.md): Escapes special patterns to turn `string` into a regular expression similarly to Python's `re.escape` function.
- [regexp_extract](/products/haybarn/functions/releases/duckdb-1.5.5/regexp_extract/index.md): If `string` contains the `regex` pattern, returns the capturing group specified by optional parameter `group`; otherwise, returns the empty string. The `group` must be a constant value. If no `group` is given, it defaults to 0. A set of optional regex `options` can be set.
- [regexp_extract_all](/products/haybarn/functions/releases/duckdb-1.5.5/regexp_extract_all/index.md): Finds non-overlapping occurrences of the `regex` in the `string` and returns the corresponding values of the capturing `group`. A set of optional regex `options` can be set.
- [regexp_full_match](/products/haybarn/functions/releases/duckdb-1.5.5/regexp_full_match/index.md): Returns `true` if the entire `string` matches the `regex`. A set of optional regex `options` can be set.
- [regexp_matches](/products/haybarn/functions/releases/duckdb-1.5.5/regexp_matches/index.md): Returns `true` if `string` contains the `regex`, `false` otherwise. A set of optional regex `options` can be set.
- [regexp_replace](/products/haybarn/functions/releases/duckdb-1.5.5/regexp_replace/index.md): If `string` contains the `regex`, replaces the matching part with `replacement`. A set of optional regex `options` can be set.
- [regexp_split_to_array](/products/haybarn/functions/releases/duckdb-1.5.5/regexp_split_to_array/index.md): Splits the `string` along the `regex`. A set of optional regex `options` can be set.
- [regexp_split_to_table](/products/haybarn/functions/releases/duckdb-1.5.5/regexp_split_to_table/index.md): No description supplied.
- [regr_avgx](/products/haybarn/functions/releases/duckdb-1.5.5/regr_avgx/index.md): Returns the average of the independent variable for non-NULL pairs in a group, where x is the independent variable and y is the dependent variable.
- [regr_avgy](/products/haybarn/functions/releases/duckdb-1.5.5/regr_avgy/index.md): Returns the average of the dependent variable for non-NULL pairs in a group, where x is the independent variable and y is the dependent variable.
- [regr_count](/products/haybarn/functions/releases/duckdb-1.5.5/regr_count/index.md): Returns the number of non-NULL number pairs in a group.
- [regr_intercept](/products/haybarn/functions/releases/duckdb-1.5.5/regr_intercept/index.md): Returns the intercept of the univariate linear regression line for non-NULL pairs in a group.
- [regr_r2](/products/haybarn/functions/releases/duckdb-1.5.5/regr_r2/index.md): Returns the coefficient of determination for non-NULL pairs in a group.
- [regr_slope](/products/haybarn/functions/releases/duckdb-1.5.5/regr_slope/index.md): Returns the slope of the linear regression line for non-NULL pairs in a group.
- [regr_sxx](/products/haybarn/functions/releases/duckdb-1.5.5/regr_sxx/index.md): No description supplied.
- [regr_sxy](/products/haybarn/functions/releases/duckdb-1.5.5/regr_sxy/index.md): Returns the population covariance of input values
- [regr_syy](/products/haybarn/functions/releases/duckdb-1.5.5/regr_syy/index.md): No description supplied.
- [remap_struct](/products/haybarn/functions/releases/duckdb-1.5.5/remap_struct/index.md): Map a struct to another struct type, potentially re-ordering, renaming and casting members and filling in defaults for missing values
- [repeat](/products/haybarn/functions/releases/duckdb-1.5.5/repeat/index.md): Repeats the `blob` `count` number of times.
- [repeat_row](/products/haybarn/functions/releases/duckdb-1.5.5/repeat_row/index.md): No description supplied.
- [replace](/products/haybarn/functions/releases/duckdb-1.5.5/replace/index.md): Replaces any occurrences of the `source` with `target` in `string`.
- [replace_type](/products/haybarn/functions/releases/duckdb-1.5.5/replace_type/index.md): Casts all fields of type1 to type2
- [reservoir_quantile](/products/haybarn/functions/releases/duckdb-1.5.5/reservoir_quantile/index.md): Gives the approximate quantile using reservoir sampling, the sample size is optional and uses 8192 as a default size.
- [reverse](/products/haybarn/functions/releases/duckdb-1.5.5/reverse/index.md): Reverses the `string`.
- [right](/products/haybarn/functions/releases/duckdb-1.5.5/right/index.md): Extract the right-most `count` characters.
- [right_grapheme](/products/haybarn/functions/releases/duckdb-1.5.5/right_grapheme/index.md): Extracts the right-most `count` grapheme clusters.
- [round](/products/haybarn/functions/releases/duckdb-1.5.5/round/index.md): Rounds x to s decimal places
- [round_even](/products/haybarn/functions/releases/duckdb-1.5.5/round_even/index.md): No description supplied.
- [roundbankers](/products/haybarn/functions/releases/duckdb-1.5.5/roundbankers/index.md): No description supplied.
- [row](/products/haybarn/functions/releases/duckdb-1.5.5/row/index.md): Create an unnamed STRUCT (tuple) containing the argument values.
- [row_number](/products/haybarn/functions/releases/duckdb-1.5.5/row_number/index.md): No description supplied.
- [row_to_json](/products/haybarn/functions/releases/duckdb-1.5.5/row_to_json/index.md): No description supplied.
- [rpad](/products/haybarn/functions/releases/duckdb-1.5.5/rpad/index.md): Pads the `string` with the `character` on the right until it has `count` characters. Truncates the `string` on the right if it has more than `count` characters.
- [rtrim](/products/haybarn/functions/releases/duckdb-1.5.5/rtrim/index.md): Removes any occurrences of any of the `characters` from the right side of the `string`. `characters` defaults to `space`.
- [second](/products/haybarn/functions/releases/duckdb-1.5.5/second/index.md): Extract the second component from a date or timestamp
- [sem](/products/haybarn/functions/releases/duckdb-1.5.5/sem/index.md): Returns the standard error of the mean
- [seq_scan](/products/haybarn/functions/releases/duckdb-1.5.5/seq_scan/index.md): No description supplied.
- [session_user](/products/haybarn/functions/releases/duckdb-1.5.5/session_user/index.md): No description supplied.
- [set_bit](/products/haybarn/functions/releases/duckdb-1.5.5/set_bit/index.md): Sets the nth bit in bitstring to newvalue; the first (leftmost) bit is indexed 0. Returns a new bitstring
- [setseed](/products/haybarn/functions/releases/duckdb-1.5.5/setseed/index.md): Sets the seed to be used for the random function
- [sha1](/products/haybarn/functions/releases/duckdb-1.5.5/sha1/index.md): Returns a `VARCHAR` with the SHA-1 hash of the `blob`.
- [sha256](/products/haybarn/functions/releases/duckdb-1.5.5/sha256/index.md): Returns a `VARCHAR` with the SHA-256 hash of the `blob`.
- [show](/products/haybarn/functions/releases/duckdb-1.5.5/show/index.md): No description supplied.
- [show_databases](/products/haybarn/functions/releases/duckdb-1.5.5/show_databases/index.md): No description supplied.
- [show_tables](/products/haybarn/functions/releases/duckdb-1.5.5/show_tables/index.md): No description supplied.
- [show_tables_expanded](/products/haybarn/functions/releases/duckdb-1.5.5/show_tables_expanded/index.md): No description supplied.
- [sign](/products/haybarn/functions/releases/duckdb-1.5.5/sign/index.md): Returns the sign of x as -1, 0 or 1
- [signbit](/products/haybarn/functions/releases/duckdb-1.5.5/signbit/index.md): Returns whether the signbit is set or not
- [sin](/products/haybarn/functions/releases/duckdb-1.5.5/sin/index.md): Computes the sin of x
- [sinh](/products/haybarn/functions/releases/duckdb-1.5.5/sinh/index.md): Computes the hyperbolic sin of x
- [skewness](/products/haybarn/functions/releases/duckdb-1.5.5/skewness/index.md): Returns the skewness of all input values.
- [sleep_ms](/products/haybarn/functions/releases/duckdb-1.5.5/sleep_ms/index.md): Sleeps for the specified number of milliseconds and returns NULL
- [sniff_csv](/products/haybarn/functions/releases/duckdb-1.5.5/sniff_csv/index.md): No description supplied.
- [split](/products/haybarn/functions/releases/duckdb-1.5.5/split/index.md): Splits the `string` along the `separator`.
- [split_part](/products/haybarn/functions/releases/duckdb-1.5.5/split_part/index.md): No description supplied.
- [sql_auto_complete](/products/haybarn/functions/releases/duckdb-1.5.5/sql_auto_complete/index.md): No description supplied.
- [sqrt](/products/haybarn/functions/releases/duckdb-1.5.5/sqrt/index.md): Returns the square root of x
- [st_asbinary](/products/haybarn/functions/releases/duckdb-1.5.5/st_asbinary/index.md): Returns the Well-Known Binary (WKB) representation of the geometry
- [st_astext](/products/haybarn/functions/releases/duckdb-1.5.5/st_astext/index.md): Returns the Well-Known Text (WKT) representation of the geometry
- [st_aswkb](/products/haybarn/functions/releases/duckdb-1.5.5/st_aswkb/index.md): Returns the Well-Known Binary (WKB) representation of the geometry
- [st_aswkt](/products/haybarn/functions/releases/duckdb-1.5.5/st_aswkt/index.md): Returns the Well-Known Text (WKT) representation of the geometry
- [st_crs](/products/haybarn/functions/releases/duckdb-1.5.5/st_crs/index.md): Returns the Coordinate Reference System (CRS) identifier of the geometry
- [st_geomfromwkb](/products/haybarn/functions/releases/duckdb-1.5.5/st_geomfromwkb/index.md): Creates a geometry from Well-Known Binary (WKB) representation
- [st_intersects_extent](/products/haybarn/functions/releases/duckdb-1.5.5/st_intersects_extent/index.md): Returns true if the geometries bounding boxes intersect
- [st_setcrs](/products/haybarn/functions/releases/duckdb-1.5.5/st_setcrs/index.md): Sets the Coordinate Reference System (CRS) identifier of the geometry
- [starts_with](/products/haybarn/functions/releases/duckdb-1.5.5/starts_with/index.md): Returns `true` if `string` begins with `search_string`.
- [stats](/products/haybarn/functions/releases/duckdb-1.5.5/stats/index.md): Returns a string with statistics about the expression. Expression can be a column, constant, or SQL expression
- [stddev](/products/haybarn/functions/releases/duckdb-1.5.5/stddev/index.md): Returns the sample standard deviation
- [stddev_pop](/products/haybarn/functions/releases/duckdb-1.5.5/stddev_pop/index.md): Returns the population standard deviation.
- [stddev_samp](/products/haybarn/functions/releases/duckdb-1.5.5/stddev_samp/index.md): Returns the sample standard deviation
- [storage_info](/products/haybarn/functions/releases/duckdb-1.5.5/storage_info/index.md): No description supplied.
- [str_split](/products/haybarn/functions/releases/duckdb-1.5.5/str_split/index.md): Splits the `string` along the `separator`.
- [str_split_regex](/products/haybarn/functions/releases/duckdb-1.5.5/str_split_regex/index.md): Splits the `string` along the `regex`. A set of optional regex `options` can be set.
- [strftime](/products/haybarn/functions/releases/duckdb-1.5.5/strftime/index.md): Converts a `date` to a string according to the format string.
- [string_agg](/products/haybarn/functions/releases/duckdb-1.5.5/string_agg/index.md): Concatenates the column string values with an optional separator.
- [string_split](/products/haybarn/functions/releases/duckdb-1.5.5/string_split/index.md): Splits the `string` along the `separator`.
- [string_split_regex](/products/haybarn/functions/releases/duckdb-1.5.5/string_split_regex/index.md): Splits the `string` along the `regex`. A set of optional regex `options` can be set.
- [string_to_array](/products/haybarn/functions/releases/duckdb-1.5.5/string_to_array/index.md): Splits the `string` along the `separator`.
- [strip_accents](/products/haybarn/functions/releases/duckdb-1.5.5/strip_accents/index.md): Strips accents from `string`.
- [strlen](/products/haybarn/functions/releases/duckdb-1.5.5/strlen/index.md): Number of bytes in `string`.
- [strpos](/products/haybarn/functions/releases/duckdb-1.5.5/strpos/index.md): Returns location of first occurrence of `search_string` in `string`, counting from 1. Returns 0 if no match found.
- [strptime](/products/haybarn/functions/releases/duckdb-1.5.5/strptime/index.md): Converts the `string` text to timestamp applying the format strings in the list until one succeeds. Throws an error on failure. To return `NULL` on failure, use try_strptime.
- [struct_concat](/products/haybarn/functions/releases/duckdb-1.5.5/struct_concat/index.md): Merge the multiple STRUCTs into a single STRUCT.
- [struct_contains](/products/haybarn/functions/releases/duckdb-1.5.5/struct_contains/index.md): Check if an unnamed STRUCT contains the value.
- [struct_extract](/products/haybarn/functions/releases/duckdb-1.5.5/struct_extract/index.md): Extract the named entry from the STRUCT.
- [struct_extract_at](/products/haybarn/functions/releases/duckdb-1.5.5/struct_extract_at/index.md): Extract the entry from the STRUCT by position (starts at 1!).
- [struct_has](/products/haybarn/functions/releases/duckdb-1.5.5/struct_has/index.md): Check if an unnamed STRUCT contains the value.
- [struct_indexof](/products/haybarn/functions/releases/duckdb-1.5.5/struct_indexof/index.md): Get the position of the entry in an unnamed STRUCT, starting at 1.
- [struct_insert](/products/haybarn/functions/releases/duckdb-1.5.5/struct_insert/index.md): Adds field(s)/value(s) to an existing STRUCT with the argument values. The entry name(s) will be the bound variable name(s)
- [struct_keys](/products/haybarn/functions/releases/duckdb-1.5.5/struct_keys/index.md): Returns the field names of a STRUCT as a list
- [struct_pack](/products/haybarn/functions/releases/duckdb-1.5.5/struct_pack/index.md): Create a STRUCT containing the argument values. The entry name will be the bound variable name.
- [struct_position](/products/haybarn/functions/releases/duckdb-1.5.5/struct_position/index.md): Get the position of the entry in an unnamed STRUCT, starting at 1.
- [struct_update](/products/haybarn/functions/releases/duckdb-1.5.5/struct_update/index.md): Changes field(s)/value(s) to an existing STRUCT with the argument values. The entry name(s) will be the bound variable name(s)
- [struct_values](/products/haybarn/functions/releases/duckdb-1.5.5/struct_values/index.md): Returns the field values of a STRUCT as an UnnamedStruct
- [substr](/products/haybarn/functions/releases/duckdb-1.5.5/substr/index.md): Extracts substring starting from character `start` up to the end of the string. If optional argument `length` is set, extracts a substring of `length` characters instead. Note that a `start` value of `1` refers to the first character of the `string`.
- [substring](/products/haybarn/functions/releases/duckdb-1.5.5/substring/index.md): Extracts substring starting from character `start` up to the end of the string. If optional argument `length` is set, extracts a substring of `length` characters instead. Note that a `start` value of `1` refers to the first character of the `string`.
- [substring_grapheme](/products/haybarn/functions/releases/duckdb-1.5.5/substring_grapheme/index.md): Extracts substring starting from grapheme clusters `start` up to the end of the string. If optional argument `length` is set, extracts a substring of `length` grapheme clusters instead. Note that a `start` value of `1` refers to the `first` character of the `string`.
- [subtract](/products/haybarn/functions/releases/duckdb-1.5.5/subtract/index.md): No description supplied.
- [suffix](/products/haybarn/functions/releases/duckdb-1.5.5/suffix/index.md): Returns `true` if `string` ends with `search_string`.
- [sum](/products/haybarn/functions/releases/duckdb-1.5.5/sum/index.md): Calculates the sum value for all tuples in arg.
- [sum_no_overflow](/products/haybarn/functions/releases/duckdb-1.5.5/sum_no_overflow/index.md): Internal only. Calculates the sum value for all tuples in arg without overflow checks.
- [sumkahan](/products/haybarn/functions/releases/duckdb-1.5.5/sumkahan/index.md): Calculates the sum using a more accurate floating point summation (Kahan Sum).
- [summary](/products/haybarn/functions/releases/duckdb-1.5.5/summary/index.md): No description supplied.
- [switch](/products/haybarn/functions/releases/duckdb-1.5.5/switch/index.md): Creates a switch statement similar to CASE WHEN/THEN
- [table_info](/products/haybarn/functions/releases/duckdb-1.5.5/table_info/index.md): No description supplied.
- [tan](/products/haybarn/functions/releases/duckdb-1.5.5/tan/index.md): Computes the tan of x
- [tanh](/products/haybarn/functions/releases/duckdb-1.5.5/tanh/index.md): Computes the hyperbolic tan of x
- [test_all_types](/products/haybarn/functions/releases/duckdb-1.5.5/test_all_types/index.md): No description supplied.
- [test_vector_types](/products/haybarn/functions/releases/duckdb-1.5.5/test_vector_types/index.md): No description supplied.
- [time_bucket](/products/haybarn/functions/releases/duckdb-1.5.5/time_bucket/index.md): Truncate TIMESTAMPTZ by the specified interval bucket_width. Buckets are aligned relative to origin TIMESTAMPTZ. The origin defaults to 2000-01-03 00:00:00+00 for buckets that do not include a month or year interval, and to 2000-01-01 00:00:00+00 for month and year buckets
- [timetz_byte_comparable](/products/haybarn/functions/releases/duckdb-1.5.5/timetz_byte_comparable/index.md): Converts a TIME WITH TIME ZONE to an integer sort key
- [timezone](/products/haybarn/functions/releases/duckdb-1.5.5/timezone/index.md): Extract the timezone component from a date or timestamp
- [timezone_hour](/products/haybarn/functions/releases/duckdb-1.5.5/timezone_hour/index.md): Extract the timezone_hour component from a date or timestamp
- [timezone_minute](/products/haybarn/functions/releases/duckdb-1.5.5/timezone_minute/index.md): Extract the timezone_minute component from a date or timestamp
- [to_base](/products/haybarn/functions/releases/duckdb-1.5.5/to_base/index.md): Converts `number` to a string in the given base `radix`, optionally padding with leading zeros to `min_length`.
- [to_base64](/products/haybarn/functions/releases/duckdb-1.5.5/to_base64/index.md): Converts a `blob` to a base64 encoded string.
- [to_binary](/products/haybarn/functions/releases/duckdb-1.5.5/to_binary/index.md): Converts the `string` to binary representation.
- [to_centuries](/products/haybarn/functions/releases/duckdb-1.5.5/to_centuries/index.md): Construct a century interval
- [to_days](/products/haybarn/functions/releases/duckdb-1.5.5/to_days/index.md): Construct a day interval
- [to_decades](/products/haybarn/functions/releases/duckdb-1.5.5/to_decades/index.md): Construct a decade interval
- [to_hex](/products/haybarn/functions/releases/duckdb-1.5.5/to_hex/index.md): Converts `blob` to `VARCHAR` using hexadecimal encoding.
- [to_hours](/products/haybarn/functions/releases/duckdb-1.5.5/to_hours/index.md): Construct a hour interval
- [to_json](/products/haybarn/functions/releases/duckdb-1.5.5/to_json/index.md): No description supplied.
- [to_microseconds](/products/haybarn/functions/releases/duckdb-1.5.5/to_microseconds/index.md): Construct a microsecond interval
- [to_millennia](/products/haybarn/functions/releases/duckdb-1.5.5/to_millennia/index.md): Construct a millenium interval
- [to_milliseconds](/products/haybarn/functions/releases/duckdb-1.5.5/to_milliseconds/index.md): Construct a millisecond interval
- [to_minutes](/products/haybarn/functions/releases/duckdb-1.5.5/to_minutes/index.md): Construct a minute interval
- [to_months](/products/haybarn/functions/releases/duckdb-1.5.5/to_months/index.md): Construct a month interval
- [to_quarters](/products/haybarn/functions/releases/duckdb-1.5.5/to_quarters/index.md): Construct a quarter interval
- [to_seconds](/products/haybarn/functions/releases/duckdb-1.5.5/to_seconds/index.md): Construct a second interval
- [to_timestamp](/products/haybarn/functions/releases/duckdb-1.5.5/to_timestamp/index.md): Converts secs since epoch to a timestamp with time zone
- [to_weeks](/products/haybarn/functions/releases/duckdb-1.5.5/to_weeks/index.md): Construct a week interval
- [to_years](/products/haybarn/functions/releases/duckdb-1.5.5/to_years/index.md): Construct a year interval
- [today](/products/haybarn/functions/releases/duckdb-1.5.5/today/index.md): No description supplied.
- [transaction_timestamp](/products/haybarn/functions/releases/duckdb-1.5.5/transaction_timestamp/index.md): Returns the current timestamp
- [translate](/products/haybarn/functions/releases/duckdb-1.5.5/translate/index.md): Replaces each character in `string` that matches a character in the `from` set with the corresponding character in the `to` set. If `from` is longer than `to`, occurrences of the extra characters in `from` are deleted.
- [trim](/products/haybarn/functions/releases/duckdb-1.5.5/trim/index.md): Removes any occurrences of any of the `characters` from either side of the `string`. `characters` defaults to `space`.
- [trunc](/products/haybarn/functions/releases/duckdb-1.5.5/trunc/index.md): Truncates the number
- [truncate_duckdb_logs](/products/haybarn/functions/releases/duckdb-1.5.5/truncate_duckdb_logs/index.md): No description supplied.
- [try_strptime](/products/haybarn/functions/releases/duckdb-1.5.5/try_strptime/index.md): Converts the `string` text to timestamp according to the format string. Returns `NULL` on failure.
- [txid_current](/products/haybarn/functions/releases/duckdb-1.5.5/txid_current/index.md): Returns the current transaction’s ID (a BIGINT). It will assign a new one if the current transaction does not have one already
- [typeof](/products/haybarn/functions/releases/duckdb-1.5.5/typeof/index.md): Returns the name of the data type of the result of the expression
- [ucase](/products/haybarn/functions/releases/duckdb-1.5.5/ucase/index.md): Converts `string` to upper case.
- [unbin](/products/haybarn/functions/releases/duckdb-1.5.5/unbin/index.md): Converts a `value` from binary representation to a blob.
- [unhex](/products/haybarn/functions/releases/duckdb-1.5.5/unhex/index.md): Converts a `value` from hexadecimal representation to a blob.
- [unicode](/products/haybarn/functions/releases/duckdb-1.5.5/unicode/index.md): Returns an `INTEGER` representing the `unicode` codepoint of the first character in the `string`.
- [union_extract](/products/haybarn/functions/releases/duckdb-1.5.5/union_extract/index.md): Extract the value with the named tags from the union. NULL if the tag is not currently selected
- [union_tag](/products/haybarn/functions/releases/duckdb-1.5.5/union_tag/index.md): Retrieve the currently selected tag of the union as an ENUM
- [union_value](/products/haybarn/functions/releases/duckdb-1.5.5/union_value/index.md): Create a single member UNION containing the argument value. The tag of the value will be the bound variable name
- [unnest](/products/haybarn/functions/releases/duckdb-1.5.5/unnest/index.md): No description supplied.
- [unpivot_list](/products/haybarn/functions/releases/duckdb-1.5.5/unpivot_list/index.md): Identical to list_value, but generated as part of unpivot for better error messages.
- [upper](/products/haybarn/functions/releases/duckdb-1.5.5/upper/index.md): Converts `string` to upper case.
- [url_decode](/products/haybarn/functions/releases/duckdb-1.5.5/url_decode/index.md): Decodes a URL from a representation using Percent-Encoding.
- [url_encode](/products/haybarn/functions/releases/duckdb-1.5.5/url_encode/index.md): Encodes a URL to a representation using Percent-Encoding.
- [user](/products/haybarn/functions/releases/duckdb-1.5.5/user/index.md): No description supplied.
- [user_agent](/products/haybarn/functions/releases/duckdb-1.5.5/user_agent/index.md): No description supplied.
- [uuid](/products/haybarn/functions/releases/duckdb-1.5.5/uuid/index.md): Returns a random UUID v4 similar to this: eeccb8c5-9943-b2bb-bb5e-222f4e14b687
- [uuid_extract_timestamp](/products/haybarn/functions/releases/duckdb-1.5.5/uuid_extract_timestamp/index.md): Extract the timestamp for the given UUID v7.
- [uuid_extract_version](/products/haybarn/functions/releases/duckdb-1.5.5/uuid_extract_version/index.md): Extract a version for the given UUID.
- [uuidv4](/products/haybarn/functions/releases/duckdb-1.5.5/uuidv4/index.md): Returns a random UUIDv4 similar to this: eeccb8c5-9943-b2bb-bb5e-222f4e14b687
- [uuidv7](/products/haybarn/functions/releases/duckdb-1.5.5/uuidv7/index.md): Returns a random UUID v7 similar to this: 019482e4-1441-7aad-8127-eec99573b0a0
- [var_pop](/products/haybarn/functions/releases/duckdb-1.5.5/var_pop/index.md): Returns the population variance.
- [var_samp](/products/haybarn/functions/releases/duckdb-1.5.5/var_samp/index.md): Returns the sample variance of all input values.
- [variance](/products/haybarn/functions/releases/duckdb-1.5.5/variance/index.md): Returns the sample variance of all input values.
- [variant_bytes_to_variant](/products/haybarn/functions/releases/duckdb-1.5.5/variant_bytes_to_variant/index.md): No description supplied.
- [variant_extract](/products/haybarn/functions/releases/duckdb-1.5.5/variant_extract/index.md): No description supplied.
- [variant_normalize](/products/haybarn/functions/releases/duckdb-1.5.5/variant_normalize/index.md): Normalizes the `input_variant` to a canonical representation.
- [variant_to_parquet_variant](/products/haybarn/functions/releases/duckdb-1.5.5/variant_to_parquet_variant/index.md): No description supplied.
- [variant_typeof](/products/haybarn/functions/releases/duckdb-1.5.5/variant_typeof/index.md): Returns the internal type of the `input_variant`.
- [vector_type](/products/haybarn/functions/releases/duckdb-1.5.5/vector_type/index.md): Returns the VectorType of a given column
- [verify_external](/products/haybarn/functions/releases/duckdb-1.5.5/verify_external/index.md): No description supplied.
- [verify_fetch_row](/products/haybarn/functions/releases/duckdb-1.5.5/verify_fetch_row/index.md): No description supplied.
- [verify_parallelism](/products/haybarn/functions/releases/duckdb-1.5.5/verify_parallelism/index.md): No description supplied.
- [verify_serializer](/products/haybarn/functions/releases/duckdb-1.5.5/verify_serializer/index.md): No description supplied.
- [version](/products/haybarn/functions/releases/duckdb-1.5.5/version/index.md): Returns the currently active version of DuckDB in this format: v0.3.2 
- [wavg](/products/haybarn/functions/releases/duckdb-1.5.5/wavg/index.md): No description supplied.
- [week](/products/haybarn/functions/releases/duckdb-1.5.5/week/index.md): Extract the week component from a date or timestamp
- [weekday](/products/haybarn/functions/releases/duckdb-1.5.5/weekday/index.md): Extract the weekday component from a date or timestamp
- [weekofyear](/products/haybarn/functions/releases/duckdb-1.5.5/weekofyear/index.md): Extract the weekofyear component from a date or timestamp
- [weighted_avg](/products/haybarn/functions/releases/duckdb-1.5.5/weighted_avg/index.md): No description supplied.
- [which_secret](/products/haybarn/functions/releases/duckdb-1.5.5/which_secret/index.md): No description supplied.
- [write_log](/products/haybarn/functions/releases/duckdb-1.5.5/write_log/index.md): Writes to the logger
- [xor](/products/haybarn/functions/releases/duckdb-1.5.5/xor/index.md): Bitwise XOR
- [year](/products/haybarn/functions/releases/duckdb-1.5.5/year/index.md): Extract the year component from a date or timestamp
- [yearweek](/products/haybarn/functions/releases/duckdb-1.5.5/yearweek/index.md): Extract the yearweek component from a date or timestamp