Results of 1 - 3 of about 3 for coarser (0.001 sec.)
- Timestamp with Time Zone Functions 10938
- 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
...dth bucket_width . The grid is anchored at 2000-01-01 00:00:00+00:00[ + offset] when bucket_width is a number of months or coarser units, else 2000-01-03 00:00:00+00:00[ + offset] . Note that 2000-01-03 is a Monday. time_bucket(bucket_width, timestamptz...s anchored at the origin timestamp, which defaults to 2000-01-01 00:00:00+00:00 when bucket_width is a number of months or coarser units, else 2000-01-03 00:00:00+00:00 . Note that 2000-01-03 is a Monday. time_bucket(bucket_width, timestamptz[, timezone...rigin timestamp, which defaults to 2000-01-01 00:00:00 in the provided timezone when bucket_width is a number of months or coarser units, else 2000-01-03 00:00:00 in the provided timezone . The default timezone is 'UTC' . Note that 2000-01-03 is a Monda... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamptz.html
- Date Functions 10231
- This section describes functions and operators for examining and manipulating DATE values. Date Operators The table below shows the available mathematical operators for DATE types. Operator Description Example Result + addition of days (int
...to a grid of width bucket_width . The grid is anchored at 2000-01-01[ + offset] when bucket_width is a number of months or coarser units, else 2000-01-03[ + offset] . Note that 2000-01-03 is a Monday. time_bucket(bucket_width, date[, origin]) Truncate t...th . The grid is anchored at the origin timestamp, which defaults to 2000-01-01 when bucket_width is a number of months or coarser units, else 2000-01-03 . Note that 2000-01-03 is a Monday. today() Current date (start of current transaction) in the loca...to a grid of width bucket_width . The grid is anchored at 2000-01-01[ + offset] when bucket_width is a number of months or coarser units, else 2000-01-03[ + offset] . Note that 2000-01-03 is a Monday. | | Example | time_bucket(INTERVAL '2 months', DATE... - https://man.mtool.work/duckdb/2.0/sql/functions/date.html
- Timestamp Functions 6696
- 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
...of width bucket_width . The grid is anchored at 2000-01-01 00:00:00[ + offset] when bucket_width is a number of months or coarser units, else 2000-01-03 00:00:00[ + offset] . Note that 2000-01-03 is a Monday. time_bucket(bucket_width, timestamp[, origi...grid is anchored at the origin timestamp, which defaults to 2000-01-01 00:00:00 when bucket_width is a number of months or coarser units, else 2000-01-03 00:00:00 . Note that 2000-01-03 is a Monday. try_strptime(text, format-list) Converts the string te...a grid of width bucket_width . The grid includes 2000-01-01 00:00:00[ + offset] when bucket_width is a number of months or coarser units, else 2000-01-03 00:00:00[ + offset] . Note that 2000-01-03 is a Monday. | | Example | time_bucket(INTERVAL '10 minu... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamp.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work