{"id":11385,"date":"2023-10-18T02:12:01","date_gmt":"2023-10-18T09:12:01","guid":{"rendered":"https:\/\/www.mysqltutorial.org\/?page_id=11385"},"modified":"2023-10-18T02:14:21","modified_gmt":"2023-10-18T09:14:21","slug":"mysql-maketime","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-date-functions\/mysql-maketime\/","title":{"rendered":"MySQL MAKETIME() Function"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to use the MySQL MAKETIME()<\/code> function to create a time based on hour, minute, and second.<\/p>\n\n\n\n

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

The MAKETIME()<\/code> function allows you to create a time<\/a> value by specifying the hour, minute, and second components. <\/p>\n\n\n\n

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

MAKETIME(hour,minute,second)<\/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
  • hour<\/code>: The hour component of the time, which is an integer value between 0 and 23.<\/li>\n\n\n\n
  • minute<\/code>: The minute component of the time, which is an integer value between 0 and 59.<\/li>\n\n\n\n
  • second<\/code>: The second component of the time, which can have a fractional part, so it allows specifying fractions of a second.<\/li>\n<\/ul>\n\n\n\n
    MySQL MAKETIME() function example<\/h2>\n\n\n\n
    The following example uses the MAKETIME()<\/code> function to create a time value for 12:15:30<\/code> (12 hours, 15 minutes, and 30 seconds):<\/p>\n\n\n
    SELECT<\/span> MAKETIME<\/span>(12<\/span>, 15<\/span>, 30<\/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
    +----------------------+<\/span>\n| MAKETIME(12, 15, 30) |\n+----------------------+<\/span>\n| 12:15:30             |\n+----------------------+<\/span>\n1 row in set<\/span> (0.00<\/span> sec)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    Summary<\/h2>\n\n\n\n
      \n
    • Use the MAKETIME()<\/code> function to create a time based on hour, minute, and second.<\/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