blob: 9dc38c3e79129da6859b5964eebe180405d166ed (
plain) (
tree)
|
|
second(date) - Returns the second of date
date is a string in the format of 'yyyy-MM-dd HH:mm:ss' or 'HH:mm:ss'.
Example:
> SELECT second('2009-07-30 12:58:59') FROM src LIMIT 1;
59
> SELECT second('12:58:59') FROM src LIMIT 1;
59
|