Name

second — get second from a datetime

Synopsis

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

Example24.366.Simple example

Get current second.

SQL> select second (now ());
callret
INTEGER
_______________________________________________________________________________

28