Results of 1 - 10 of about 11 for years (0.002 sec.)
- Interval Type 13852
- INTERVAL s represent periods of time that can be added to or subtracted from DATE , TIMESTAMP , TIMESTAMPTZ , or TIME values. Name Description INTERVAL Period of time An INTERVAL can be constructed by providing amounts together with units.
...runcated to integers when used with unit keywords (unless the unit is SECONDS or MILLISECONDS ). sql SELECT INTERVAL '1.5' YEARS; -- Returns 12 months; equivalent to `to_years(CAST(trunc(1.5) AS INTEGER))` For more precision, include the unit in the s...tring or use a more granular unit; e.g., INTERVAL '1.5 years' or INTERVAL 18 MONTHS . Three independent basis units are necessary because a month does not correspond to a fixed amount...nge(12) t(i); When INTERVAL s are deconstructed via the datepart function, the months component is additionally split into years and months, and the microseconds component is split into hours, minutes and microseconds. The days component is not split... - https://man.mtool.work/duckdb/2.0/sql/data_types/interval.html
- Interval Functions 10686
- This section describes functions and operators for examining and manipulating INTERVAL values. Interval Operators The table below shows the available mathematical operators for INTERVAL types. Operator Description Example Result + Addition
...rval of integer quarters. to_seconds(integer) Construct a second interval. to_weeks(integer) Construct a week interval. to_years(integer) Construct a year interval. Only the documented date part components are defined for intervals. date_part(part, in...| to_weeks(integer) | Description | Construct a week interval. | | Example | to_weeks(5) | | Result | INTERVAL 35 DAY | to_years(integer) | Description | Construct a year interval. | | Example | to_years(5) | | Result | INTERVAL 5 YEAR |... - https://man.mtool.work/duckdb/2.0/sql/functions/interval.html
- Date Types 9210
- 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
... - https://man.mtool.work/duckdb/2.0/sql/data_types/date.html
- Timestamp Functions 8268
- This section describes functions and operators for examining and manipulating TIMESTAMP values . See also the related TIMESTAMPTZ functions . Timestamp Operators The table below shows the available mathematical operators for TIMESTAMP types
...me difference between the two timestamps. | | Example | age(TIMESTAMP '2001-04-10', TIMESTAMP '1992-09-20') | | Result | 8 years 6 months 20 days | age(timestamp) | Description | Subtract from current_date. | | Example | age(TIMESTAMP '1992-09-20') |...| Result | 29 years 1 month 27 days 12:39:00.844 | ago(interval) | Description | Subtracts an interval from the current timestamp, returning a... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamp.html
- Prepared Statements 8268
- DuckDB supports prepared statements where parameters are substituted when the query is executed. This can improve readability and is useful for preventing SQL injections . Syntax There are three syntaxes for denoting parameters in prepared
...35), ('Bob', 41), ('Bea', 25); In our example query, we'll look for people whose name starts with a B and are at least 40 years old. This will return a single row <'Bob', 41> . Auto-Incremented Parameters: ? DuckDB supports using prepared statements... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/prepared_statements.html
- Environment 8090
- The environment where DuckDB is run has an obvious impact on performance. This page focuses on the effects of the hardware configuration and the operating system used. Hardware Configuration CPU DuckDB's officially supported architectures a
...kDB can run on them with high performance. Linux DuckDB runs on all mainstream Linux distributions released in the last ≈5 years. If you don't have a particular preference, we recommend using Ubuntu Linux LTS due to its stability and the fact that mos... - https://man.mtool.work/duckdb/2.0/guides/performance/environment.html
- Timestamp with Time Zone Functions 8090
- This section describes functions and operators for examining and manipulating TIMESTAMP WITH TIME ZONE (or TIMESTAMPTZ ) values . See also the related TIMESTAMP functions . Time zone support is provided by the built-in ICU extension . In th
...ifference between the two timestamps. | | Example | age(TIMESTAMPTZ '2001-04-10', TIMESTAMPTZ '1992-09-20') | | Result | 8 years 6 months 20 days | age(timestamptz) | Description | Subtract from current_date. | | Example | age(TIMESTAMP '1992-09-20')...| | Result | 29 years 1 month 27 days 12:39:00.844 | date_diff(part, starttimestamptz, endtimestamptz) | Description | The signed number of part... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamptz.html
- Run Queries 7895
- 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
....Next() { var ( name string age int ) if err := rows.Scan(&name, &age); err != nil { log.Fatal(err) } log.Printf("%s is %d years old", name, age) } if err := rows.Err(); err != nil { log.Fatal(err) } When the column set is not known ahead of time, row... - https://man.mtool.work/duckdb/2.0/clients/go/querying.html
- Analyzing a Git Repository 7895
- You can use DuckDB to analyze Git logs using the output of the git log command . Exporting the Git Log We start by picking a character that doesn't occur in any part of the commit log (author names, messages, etc). Since version v1.2.0, Duc
...──────┴──────────────────────────────────────────────────────────────────────────────────┘ We see a steady growth over the years – especially considering that many of DuckDB's functionalities and clients, which were originally part of the main reposit... - https://man.mtool.work/duckdb/2.0/guides/snippets/analyze_git_repository.html
- Timestamp Types 7717
- 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
...e bin they fall into. Temporal binning is simply applying this practice to instants; for example, by binning instants into years, months and days. Temporal binning rules are complex, and generally come in two sets: time zones and calendars . For most... - https://man.mtool.work/duckdb/2.0/sql/data_types/timestamp.html
DuckDB 2.0 Documentation / man.mtool.work