⌘K ctrl+k
Search Shortcut cmd + k | ctrl + k
DuckDB 2.0 ドキュメント 全文検索
per page, with , order by , clip by
Results of 1 - 1 of about 1 for startdate (0.000 sec.)
Date Functions 9414
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 ... otion. Name Description date_add(date, interval) Add the interval to the date and return a DATETIME value. date_diff(part, startdate, enddate) The number of part boundaries 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 enddate , truncated to whole multiples of part . date_tr ... TIME value. | | Example | date_add(DATE '1992-09-15', INTERVAL 2 MONTH) | | Result | 1992-11-15 00:00:00 | date_diff(part, startdate, enddate) | Description | The number of part boundaries between startdate and enddate , inclusive of the larger date and e ...
https://man.mtool.work/duckdb/2.0/sql/functions/date.html
PREV 1 NEXT
DuckDB 2.0 Documentation / man.mtool.work