{"id":11435,"date":"2023-10-19T18:15:37","date_gmt":"2023-10-20T01:15:37","guid":{"rendered":"https:\/\/www.mysqltutorial.org\/?page_id=11435"},"modified":"2023-10-19T18:16:18","modified_gmt":"2023-10-20T01:16:18","slug":"mysql-from_days","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-date-functions\/mysql-from_days\/","title":{"rendered":"MySQL FROM_DAYS() Function"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to use the MySQL FROM_DAYS()<\/code> function to convert a numeric day count into a date.<\/p>\n\n\n\n

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

The FROM_DAYS()<\/code> function returns a numeric day count into a date<\/a>.<\/p>\n\n\n\n

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

FROM_DAYS(days)<\/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
  • days<\/code>: This parameter is the number of days since '0000-00-00'<\/code> that you want to convert into a date.<\/li>\n<\/ul>\n\n\n\n
    In practice, you use the function when working with date data stored as the number of days since the date '0000-00-00'<\/code>.<\/p>\n\n\n\n
    MySQL FROM_DAYS() function example<\/h2>\n\n\n\n
    The following example uses the FROM_DAYS()<\/code> function to convert a numeric day count into a date:<\/p>\n\n\n
    SELECT<\/span> \n  FROM_DAYS<\/span>(737989<\/span>) AS<\/span> converted_date;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    Output:<\/p>\n\n\n
    +----------------+\n| converted_date |\n+----------------+\n| 2020-07-18     |\n+----------------+\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 MySQL FROM_DAYS()<\/code> function to convert a numeric day count into a date.<\/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