second()

Read(232) Label: datetime vlaue, get, second,

Description:

Get the second from a specified datetime value.

Syntax:

second(datetimeExp)

Note:

The function gets the second from the datetime value datetimeExp.

Parameters:

datetimeExp

Expression whose result is a datetime vlaue

Return value:

An integer

Example:

second(datetime("19800227","yyyyMMdd"))

0

second("1972-11-08 10:20:30")

30

second(datetime("2006-01-15 13:20:45"))

45

Related functions:

year()

month()

day() 

hour()

minute()

millisecond()