Results of 1 - 5 of about 5 for subfield (0.003 sec.)
- Time Functions 12078
- This section describes functions and operators for examining and manipulating TIME values . Time Operators The table below shows the available mathematical operators for TIME types. Operator Description Example Result + addition of an INTER
...between starttime and endtime , inclusive of the larger time and exclusive of the smaller time. date_part(part, time) Get subfield (equivalent to extract ). date_sub(part, starttime, endtime) The signed length of the interval between starttime and endti...me , truncated to whole multiples of part . extract(part FROM time) Get subfield from a time. get_current_time() Current time (start of current transaction). make_time(bigint, bigint, double) The time fo...('hour', TIME '01:02:03', TIME '06:01:03') | | Result | 5 | | Alias | datediff | date_part(part, time) | Description | Get subfield (equivalent to extract ). | | Example | date_part('minute', TIME '14:21:13') | | Result | 21 | | Alias | datepart | date_s... - https://man.mtool.work/duckdb/2.0/sql/functions/time.html
- Date Functions 9799
- 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
...between startdate and enddate , inclusive of the larger date and exclusive of the smaller date. date_part(part, date) Get subfield (equivalent to extract ). date_sub(part, startdate, enddate) The signed length of the interval between startdate and endda...h) name of the weekday. days_in_month(date) The number of days in the month of the given date. extract(part from date) Get subfield from a date. greatest(date, date) The later of two dates. isfinite(date) Returns true if the date is finite, false otherwi...DATE '1992-09-15', DATE '1992-11-14') | | Result | 2 | | Alias | datediff | date_part(part, date) | Description | Get the subfield (equivalent to extract ). | | Example | date_part('year', DATE '1992-09-20') | | Result | 1992 | | Alias | datepart | date... - https://man.mtool.work/duckdb/2.0/sql/functions/date.html
- Timestamp Functions 8990
- 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
...inclusive of the larger timestamp and exclusive of the smaller timestamp. date_part([part, ...], timestamp) Get the listed subfields as a struct . The list must be constant. date_part(part, timestamp) Get subfield (equivalent to extract ). date_sub(part,...s since the epoch. epoch(timestamp) Returns the total number of seconds since the epoch. extract(field FROM timestamp) Get subfield from a timestamp. greatest(timestamp, timestamp) The later of two timestamps. isfinite(timestamp) Returns true if the time...mestamp according to the format string . Returns NULL on failure. There are also dedicated extraction functions to get the subfields . Functions applied to infinite dates will either return the same infinite dates (e.g., greatest ) or NULL (e.g., date_pa... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamp.html
- Timestamp with Time Zone Functions 8659
- 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
...inclusive of the larger timestamp and exclusive of the smaller timestamp. date_part([part, ...], timestamp) Get the listed subfields as a struct . The list must be constant. date_part(part, timestamp) Get subfield (equivalent to extract ). date_sub(part,...e epoch. epoch_us(timestamptz) Converts a timestamptz to microseconds since the epoch. extract(field FROM timestamptz) Get subfield from a TIMESTAMP WITH TIME ZONE . last_day(timestamptz) The last day of the month. make_timestamptz(bigint, bigint, bigint...9', TIMESTAMPTZ '1992-10-01 01:58:00') | | Result | 2 | date_part([part, ...], timestamptz) | Description | Get the listed subfields as a struct . The list must be constant. | | Example | date_part(['year', 'month', 'day'], TIMESTAMPTZ '1992-09-20 20:38:... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamptz.html
- Python Client API 6379
- 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
...to an equivalent interval. SQL: normalized_interval . part ( part : ValueOrExpr , * args : ValueOrExpr ) → Expression Get subfield (equivalent to extract). Arguments: part. SQL: date_part . quarter ( * args : ValueOrExpr ) → Expression Extract the quart... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work