Description:
Get the second from a specified datetime value.
Syntax:
second(datetimeExp)
Note:
The function gets the second from the datetime value datetimeExp.
Parameter:
|
datetimeExp |
Expression whose result is a datetime value |
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 function: