Results of 1 - 10 of about 16 for formatted (0.003 sec.)
- Date Types 12736
- Name Aliases Description DATE Calendar date (year, month, day) A date specifies a combination of year, month and day. DuckDB follows the SQL standard's lead by counting dates exclusively in the Gregorian calendar, even for years before that
...calendar was in use. Dates can be created using the DATE keyword, where the data must be formatted according to the ISO 8601 format ( YYYY-MM-DD ). SELECT DATE '1992-09-20'; Special Values There are also three special dat... - https://man.mtool.work/duckdb/2.0/sql/data_types/date.html
- Time Types 12182
- The TIME and TIMETZ types specify the hour, minute, second, microsecond of a day. Name Aliases Description TIME TIME WITHOUT TIME ZONE Time of day TIMETZ TIME WITH TIME ZONE Time of day, with time zone offset TIME_NS Time of day, nanosecond
...precision Instances can be created using the type names as a keyword, where the data must be formatted according to the ISO 8601 format ( hh:mm:ss[.zzzzzz[zzz]][+-TT[:tt]] ). SELECT TIME '1992-09-20 11:30:00.123456'; 11:30:00... - https://man.mtool.work/duckdb/2.0/sql/data_types/time.html
- Utility Functions 11038
- Scalar Utility Functions The functions below are difficult to categorize into specific function types and are broadly useful. Name Description alias(column) Return the name of the column. can_cast_implicitly(source_value, target_value) Whet
...e sequence. nullif(a, b) Return NULL if a = b , else return a . Equivalent to CASE WHEN a = b THEN NULL ELSE a END . parse_formatted_bytes(string) Parse a human-readable byte size string (e.g., '16 KiB' ) into a UBIGINT number of bytes. Throws an error on...else return a. Equivalent to CASE WHEN a = b THEN NULL ELSE a END . | | Example | nullif(1+1, 2) | | Result | NULL | parse_formatted_bytes(string) | Description | Parse a human-readable byte size string (e.g., '16 KiB' ) into a UBIGINT number of bytes. Th...rows an error on invalid input. | | Example | parse_formatted_bytes('1.5 GiB') | | Result | 1610612736 | pg_typeof(expression) | Description | Returns the lower case name of the data t... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
- Run Queries 8768
- Overview Because the Go client implements database/sql , queries run through the standard methods: Exec and ExecContext send statements that do not return rows, such as INSERT or DDL, and report the number of affected rows. Query , QueryCon
...Affected() log.Printf("inserted %d rows", n) Binding Parameters Values are bound to a statement's placeholders rather than formatted into the SQL string, which avoids SQL injection and lets DuckDB reuse a plan. DuckDB accepts positional ( ? ) and numbered... - https://man.mtool.work/duckdb/2.0/clients/go/querying.html
- Python Client API 8768
- 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
...RCHAR']), 'parse_dirpath': ('parse_dirpath', 0, ['VARCHAR']), 'parse_filename': ('parse_filename', 0, ['VARCHAR']), 'parse_formatted_bytes': ('parse_formatted_bytes', 0, ['VARCHAR']), 'parse_path': ('parse_path', 0, ['VARCHAR']), 'path_join': ('path_join'...gs : ValueOrExpr ) → StrExpr The last component of the path, optionally without its extension. SQL: parse_filename . parse_formatted_bytes ( * args : ValueOrExpr ) → Expression A human-readable size such as ‘4KB' as a number of bytes. SQL: parse_formatted... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
- Run Queries 8768
- Overview A Connection runs SQL through two families of methods: The execute_* methods ( execute() and execute_batch() ) send statements that do not return rows, such as INSERT or DDL, and report the number of affected rows. The query_* meth
...eq'), name TEXT NOT NULL, data BLOB );", )?; Binding Parameters Values are bound to a statement's placeholders rather than formatted into the SQL string. DuckDB uses positional ( ? ) and numbered ( ?1 , ?2 ) placeholders. The params! macro packs a heterog... - https://man.mtool.work/duckdb/2.0/clients/rust/querying.html
- Data Ingestion 8196
- This page contains examples for data ingestion to Python using DuckDB. First, import the DuckDB package: import duckdb Then, proceed with any of the following sections. CSV Files CSV files can be read using the read_csv function, called eit
...sv("example.csv") Read multiple CSV files from a folder: duckdb.read_csv("folder/*.csv") Specify options on how the CSV is formatted internally: duckdb.read_csv("example.csv", header = False, sep = ",") Override types of the first two columns: duckdb.read... - https://man.mtool.work/duckdb/2.0/clients/python/data_ingestion.html
- CSV Auto Detection 8196
- When using read_csv , the system tries to automatically infer how to read the CSV file using the CSV sniffer . This step is necessary because CSV files are not self-describing and come in many different dialects. The auto-detection works ro
...DuckDB supports the ISO 8601 format by default for timestamps, dates and times. Unfortunately, not all dates and times are formatted using this standard. For that reason, the CSV reader also supports the dateformat and timestampformat options. Using this... - https://man.mtool.work/duckdb/2.0/data/csv/auto_detection.html
- Timestamp Types 8196
- Timestamps represent points in time. As such, they combine DATE and TIME information. They can be created using the type name followed by a string formatted according to the ISO 8601 format, YYYY-MM-DD hh:mm:ss[.zzzzzzzzz][+-TT[:tt]] , whic
... - https://man.mtool.work/duckdb/2.0/sql/data_types/timestamp.html
- Dot Commands 7624
- Dot commands are available in the DuckDB CLI client. To use one of these commands, begin the line with a period ( . ) immediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, spac
...--clear Syntax Highlighters The DuckDB CLI client has a syntax highlighter for the SQL queries and another for the duckbox-formatted result tables. Configuring the Query Syntax Highlighter By default the shell includes support for syntax highlighting. The... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
DuckDB 2.0 Documentation / man.mtool.work