Quick Ref.
Functions
date
number
string
Data Types
date
number
string
Compatibility
SECOND(d)
Engine OK Alternative
mysql yes EXTRACT(SECOND FROM d)
oracle no TO_CHAR(d,'DD')
postgres no EXTRACT(SECOND FROM (d)
sqlserver yes DATEPART(SECOND,d)

SECOND

SECOND allows you to retrieve the second from a date. 

 SECOND(d)

In this example you get the second from the date field whn.


Results
See also: