April 2008
Intermediate to advanced
566 pages
21h 55m
English
SECOND()
SECOND(time)This function returns the seconds value (0–59) for a given time. Here is an example:
SELECT NOW( ), SECOND(NOW( )); +---------------------+----------------+ | NOW( ) | SECOND(NOW( )) | +---------------------+----------------+ | 2009-05-09 14:56:11 | 11 | +---------------------+----------------+
The first field generated shows the time that this statement was
entered, using the NOW()
function. The second field displays only the seconds value for the
results of NOW().
Read now
Unlock full access