Pastaba
Prieigai prie šio puslapio reikalingas įgaliojimas. Galite bandyti prisijungti arba pakeisti katalogus.
Prieigai prie šio puslapio reikalingas įgaliojimas. Galite bandyti pakeisti katalogus.
Applies to: Databricks SQL
Databricks Runtime
Returns the week of the year of expr
.
Syntax
weekofyear(expr)
Arguments
expr
: A DATE expression.
Returns
An INTEGER.
A week is considered to start on a Monday and week 1 is the first week with >3 days.
This function is a synonym for extract(WEEK FROM expr)
.
Examples
> SELECT weekofyear('2008-02-20');
8