second
get second from a datetime
second
(in dt datetime);
Description
second takes a datetime and returns
an integer containing a number representing the second of the datetime.
Parameters
dt –
A datetime.
Return Values
An INTEGER containing the second.
Examples
Simple example
Get current second.
SQL> select second (now ());
callret
INTEGER
_______________________________________________________________________________
28
See Also
dayname,
dayofmonth,
dayofweek,
dayofyear,
quarter,
week,
month,
year,
hour,
minute,
timezone