Results of 1 - 10 of about 13 for temporal (0.003 sec.)
- Timestamp Issues 13812
- Timestamp with Time Zone Promotion Casts Working with time zones in SQL can be quite confusing at times. For example, when filtering to a date range, one might try the following query: SET timezone = 'America/Los_Angeles'; CREATE TABLE time
...date to midnight in the current time zone . In general, unless you need to use the current time zone for display (or other temporal binning operations) you should use plain TIMESTAMP s for temporal data. This will avoid confusing issues such as this, and...evious ICU-based one. Even so, time zone-aware binning is more expensive than arithmetic on plain TIMESTAMP s. If the same temporal bins are computed repeatedly, one workaround is to precompute them in a calendar table for the timestamps being modeled. F...NTERVAL 1 HOUR) tbl(ts) ) parts; You can then join this ~700K row table against any timestamp column to quickly obtain the temporal bin values for the time zone in question. The inner casts are not required, but result in a smaller table because date_par... - https://man.mtool.work/duckdb/2.0/guides/sql_features/timestamps.html
- Timestamp Types 11525
- 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
...pecified time zone, and operations on these types can be interpreted as simply manipulating tuple fields following nominal temporal logic. It is a common data cleaning problem to disambiguate such observations, which may also be stored in raw strings wit...ions . Time Zones To understand time zones and the WITH TIME ZONE types, it helps to start with two concepts: instants and temporal binning . Instants An instant is a point in absolute time, usually given as a count of some time increment from a fixed po...+00:00 , and the increment is in seconds, milliseconds, microseconds, or nanoseconds, depending on the specific data type. Temporal Binning Binning is a common practice with continuous data: A range of possible values is broken up into contiguous subsets... - https://man.mtool.work/duckdb/2.0/sql/data_types/timestamp.html
- AsOf Join 8973
- What is an AsOf Join? Time series data is not always perfectly aligned. Clocks may be slightly off, or there may be a delay between cause and effect. This can make connecting two sets of ordered data challenging. AsOf joins are a tool for s
...name came from: Give me the value of the property as of this time . More generally, however, AsOf joins embody some common temporal analytic semantics, which can be cumbersome and slow to implement in standard SQL. Portfolio Example Dataset Let's start w...default behavior of the USING keyword. See Also For implementation details, see the blog post “DuckDB's AsOf joins: Fuzzy Temporal Lookups” .... - https://man.mtool.work/duckdb/2.0/guides/sql_features/asof_join.html
- Run Queries 8569
- Overview Java applications send queries and read result sets through the familiar Statement , PreparedStatement , and ResultSet interfaces. This page covers sending queries and reading DuckDB's nested and composite types. For opening the Co
...teStruct("POINT_2D", new Object[] {1.0, 1.0}); Array line = conn.createArrayOf("POINT_2D", new Object[] {p1, p2}); Binding Temporal Parameters Date and time parameters follow the same setObject() path. When you bind a java.time or java.sql temporal value... - https://man.mtool.work/duckdb/2.0/clients/java/querying.html
- Excel Export 8569
- DuckDB supports exporting data to Excel .xlsx files via the excel extension. Please note that .xls files are not supported. To install and load the extension, run: INSTALL excel; LOAD excel; Exporting Excel Sheets To export a table to an Ex
...BLE , the following type conversions are automatically applied when writing XLSX files: Numeric types are cast to DOUBLE . Temporal types ( TIMESTAMP , DATE , TIME , etc.) are converted to Excel "serial" numbers, that is the number of days since 1900-01-... - https://man.mtool.work/duckdb/2.0/guides/file_formats/excel_export.html
- FROM and JOIN Clauses 8287
- The FROM clause specifies the source of the data on which the remainder of the query should operate. Logically, the FROM clause is where the query starts execution. The FROM clause can contain a single table, a combination of multiple table
...e longer input table and the missing entries are filled with NULL values. As-Of Joins A common operation when working with temporal or similarly-ordered data is to find the nearest (first) event in a reference table (such as prices). This is called an as.... The inequality can be any inequality condition ( >= , > , <= , < ) on any data type, but the most common form is >= on a temporal type. Any other conditions must be equalities (or NOT DISTINCT ). This means that the left/right order of the tables is si... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/from.html
- Excel Extension 8023
- The excel extension provides functions to format numbers per Excel's formatting rules by wrapping the i18npool library and to read/write Excel ( .xlsx ) files. However, please note that .xls files are not supported. Installing and Loading T
...owing type conversions are applied when writing XLSX files. Numeric types are cast to DOUBLE when writing to an XLSX file. Temporal types ( TIMESTAMP , DATE , TIME , etc.) are converted to excel "serial" numbers, that is the number of days since 1900-01-... - https://man.mtool.work/duckdb/2.0/core_extensions/excel.html
- Aggregate Functions 7882
- Examples Produce a single row containing the sum of the amount column: SELECT sum(amount) FROM sales; Produce one row per unique region, containing the sum of amount for each group: SELECT region, sum(amount) FROM sales GROUP BY region; Ret
...ss kurtosis (Fisher's definition) with bias correction according to the sample size. mad(x) The median absolute deviation. Temporal types return a positive INTERVAL . median(x) The middle value of the set. For even value counts, quantitative values are a...with bias correction according to the sample size. | | Formula | - | mad(x) | Description | The median absolute deviation. Temporal types return a positive INTERVAL . | | Formula | median(abs(x - median(x))) | median(x) | Description | The middle value o... - https://man.mtool.work/duckdb/2.0/sql/functions/aggregates.html
- Date Part Functions 7882
- 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
... - https://man.mtool.work/duckdb/2.0/sql/functions/datepart.html
- Dot Commands 7759
- 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
...ellow .highlight_colors column_name yellow bold_underline .highlight_colors numeric_value cyan underline .highlight_colors temporal_value red bold .highlight_colors string_value green bold .highlight_colors footer gray The result highlighting can be disa... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
DuckDB 2.0 Documentation / man.mtool.work