⌘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 Saturday (0.001 sec.)
Date Part Functions 9414
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 ... ecifiers Only Usable as Date Part Specifiers Specifier Description Synonyms Example dayofweek Day of the week (Sunday = 0, Saturday = 6) weekday , dow 2 dayofyear Day of the year (1-365/366) doy 215 epoch Seconds since 1970-01-01 1627991984.123456 era Gr ... ription century(date) Century. day(date) Day. dayofmonth(date) Day (synonym). dayofweek(date) Numeric weekday (Sunday = 0, Saturday = 6). dayofyear(date) Day of the year (starts from 1, i.e., January 1 = 1). decade(date) Decade (year / 10). epoch(date) S ... rtion. timezone(date) Time zone offset in seconds. week(date) ISO Week. weekday(date) Numeric weekday synonym (Sunday = 0, Saturday = 6). weekofyear(date) ISO Week (synonym). year(date) Year. yearweek(date) BIGINT of combined ISO Year number and 2-digit ...
https://man.mtool.work/duckdb/2.0/sql/functions/datepart.html
PREV 1 NEXT
DuckDB 2.0 Documentation / man.mtool.work