Results of 1 - 7 of about 7 for specifier (0.003 sec.)
- Text Functions 13395
- Text Functions and Operators This section describes functions and operators for examining and manipulating STRING values . Function Description string[index] Extracts a single character using a (1-based) index . string[begin:end] Extracts a
...end of the list respectively. Negative values are accepted. string LIKE target Returns true if the string matches the like specifier (see Pattern Matching ). string SIMILAR TO regex Returns true if the string matches the regex (see Pattern Matching ). str...this is not a cryptographic hash. hex(string) Converts the string to hexadecimal representation. ilike_escape(string, like_specifier, escape_character) Returns true if the string matches the like_specifier (see Pattern Matching ) using case-insensitive ma...Number of characters in string . length_grapheme(string) Number of grapheme clusters in string . like_escape(string, like_specifier, escape_character) Returns true if the string matches the like_specifier (see Pattern Matching ) using case-sensitive matc... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Vortex Extension 8960
- The vortex extension allows you to read and write files using the Vortex file format . It is currently available for the Linux ( linux_amd64 , linux_arm64 ) and macOS ( osx_arm64 ) distributions. Installing and Loading To install and load t
...dd the FORMAT vortex option. If the vortex extension is not loaded, using COPY ... TO 'my.vortex without the FORMAT vortex specifier will result in a CSV file.... - https://man.mtool.work/duckdb/2.0/core_extensions/vortex.html
- Date Format Functions 8833
- The strftime and strptime functions can be used to convert between DATE / TIMESTAMP values and strings. This is often required when parsing CSV files, displaying output to the user or transferring information between programs. Because there
...LECT strptime('02/50/1992', '%d/%m/%Y') AS x; Invalid Input Error: Could not parse string "02/50/1992" according to format specifier "%d/%m/%Y" 02/50/1992 ^ Error: Month out of range, expected a value between 1 and 12 To return NULL on failure, use the tr...tion: SELECT * FROM read_csv('test.csv', dateformat = '%m/%d/%Y', timestampformat = '%A, %-d %B %Y - %I:%M:%S %p'); Format Specifiers Below is a full list of all available format specifiers. Specifier Description Example %a Abbreviated weekday name. Sun,... - https://man.mtool.work/duckdb/2.0/sql/functions/dateformat.html
- Date Part Functions 8597
- The date_part , date_trunc and date_diff functions can be used to extract or manipulate parts of temporal types such as TIMESTAMP , TIMESTAMPTZ , DATE and INTERVAL . The parts to be extracted or manipulated are specified by one of the strin
...acted as integers. Since there are no infinite integer values in DuckDB, NULL s are returned for infinite timestamps. Part Specifiers Usable as Date Part Specifiers and in Intervals Specifier Description Synonyms Example century Gregorian century cent , c...of the year (1-4) quarters 3 second Seconds sec , seconds , secs , s 44 year Gregorian year yr , y , years , yrs 2021 Part Specifiers Only Usable as Date Part Specifiers Specifier Description Synonyms Example dayofweek Day of the week (Sunday = 0, Saturda... - https://man.mtool.work/duckdb/2.0/sql/functions/datepart.html
- Result Verification 8124
- The standard way of verifying results of queries is using the query statement, followed by the letter I times the number of columns that are expected in the result. After the query, four dashes ( ---- ) are expected followed by the result v
...that are logically equivalent, but formulated differently. Query labels are provided after the connection label or sorting specifier. Queries that have a query label do not need to have a result provided. Instead, the results of each of the queries with t... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/result_verification.html
- Python Client API 7997
- Connection class duckdb. Appender Bases: object append_row ( self , * args ) → None Buffer one row, one value per column, each converted as an executemany parameter would be append_rows ( self , rows : object ) → None Buffer each row of an
...s2. SQL: hamming . ilike_escape ( * args : ValueOrExpr ) → Expression Matches the pattern, ignoring case. Arguments: like_specifier, escape_character. SQL: ilike_escape . instr ( * args : ValueOrExpr ) → Expression Where the search string first occurs, o...: s2. SQL: levenshtein . like_escape ( * args : ValueOrExpr ) → Expression Whether it matches the pattern. Arguments: like_specifier, escape_character. SQL: like_escape . lower ( * args : ValueOrExpr ) → StrExpr Converts string to lower case. SQL: lower ....SQL: nfc_normalize . not_ilike_escape ( * args : ValueOrExpr ) → Expression Does not match, ignoring case. Arguments: like_specifier, escape_character. SQL: not_ilike_escape . not_like_escape ( * args : ValueOrExpr ) → Expression Does not match the patter... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
- COPY Statement 7633
- Examples Read a CSV file into the lineitem table, using auto-detected CSV options: COPY lineitem FROM 'lineitem.csv'; Read a CSV file into the lineitem table, using manually specified CSV options: COPY lineitem FROM 'lineitem.csv' (DELIMITE
...ble('my_format')); COPY ... TO Options Zero or more copy options may be provided as a part of the copy operation. The WITH specifier is optional, but if any options are specified, the parentheses are required. Parameter values can be passed in with or wit... - https://man.mtool.work/duckdb/2.0/sql/statements/copy.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work