{"id":11373,"date":"2023-10-18T01:16:33","date_gmt":"2023-10-18T08:16:33","guid":{"rendered":"https:\/\/www.mysqltutorial.org\/mysql-date-functions\/mysql-second\/"},"modified":"2023-10-18T01:21:42","modified_gmt":"2023-10-18T08:21:42","slug":"mysql-second","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-date-functions\/mysql-second\/","title":{"rendered":"MySQL SECOND() Function"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to use the MySQL SECOND()<\/code> function to get the second for a time value.<\/p>\n\n\n\n

Introduction to MySQL SECOND() function<\/h2>\n\n\n\n

The SECOND()<\/code> function allows you to extract the second component of a time value.<\/p>\n\n\n\n

Here’s the basic syntax of the SECOND()<\/code> function:<\/p>\n\n\n

SECOND(time)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this syntax:<\/p>\n\n\n\n
    \n
  • time<\/code>: The time that you want to extract the second component. The time value has the data type is TIME<\/code>.<\/li>\n<\/ul>\n\n\n\n
    The SECOND()<\/code> function returns an integer that represents the second component of the time.<\/p>\n\n\n\n
    If the time represents the time of the day, the SECOND()<\/code> function returns a value between 0 and 59. But if the time value is larger, the SECOND()<\/code> function can return values greater than 59.<\/p>\n\n\n\n
    If the time is NULL<\/code>, the SECOND()<\/code> function returns NULL<\/code>.<\/p>\n\n\n\n
    MySQL SECOND() function example<\/h2>\n\n\n\n
    The following example uses the SECOND()<\/code> function to get the second from the time '10:45:20'<\/code>:<\/p>\n\n\n
    SELECT<\/span> SECOND<\/span>('10:45:20'<\/span>);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    Output:<\/p>\n\n\n
    +--------------------+\r\n| SECOND('10:45:20') |\r\n+--------------------+\r\n|                 20 |\r\n+--------------------+\r\n1 row in set (0.00 sec)<\/code><\/span>Code language:<\/span> plaintext<\/span> (<\/span>plaintext<\/span>)<\/span><\/small><\/pre>\n\n\n
    Summary<\/h2>\n\n\n\n
      \n
    • Use the SECOND()<\/code> function to get the second component of a specific time.<\/li>\n<\/ul>\n
      \n\t
      \n\t\t
      Was this tutorial helpful? <\/div>\n\t\t
      \n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
      \n\t\t
      \n\t\t\t
      <\/div>\n\t\t\t\n\t\t\t