Name
week — get number of week from a datetime
Synopsis
week
(
|
in
dt
datetime
); |
Description
week takes a datetime and
returns an integer containing a number representing
the week of year of the datetime.
Parameters
dt
A datetime .
Return Values
An INTEGER containing number of the week of year.
Examples
Example 24.473. Simple example
Get current week of year.
SQL> select week (now ()); callret INTEGER _______________________________________________________________________________ 42