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