{"id":3052,"date":"2024-04-13T20:06:49","date_gmt":"2024-04-13T13:06:49","guid":{"rendered":"https:\/\/www.sqlitetutorial.net\/?page_id=3052"},"modified":"2024-04-13T20:09:57","modified_gmt":"2024-04-13T13:09:57","slug":"sqlite-mod","status":"publish","type":"page","link":"https:\/\/www.sqlitetutorial.net\/sqlite-math-functions\/sqlite-mod\/","title":{"rendered":"SQLite mod() Function"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to use the SQLite mod()<\/code> function to return the remainder after dividing the first argument by the second one.<\/p>\n\n\n\n

Introduction to the SQLite mod() function<\/h2>\n\n\n\n

In SQLite, the mod()<\/code> function returns the remainder after dividing the first argument by the second one.<\/p>\n\n\n\n

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

mod(x,y)<\/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
  • x<\/code> is the dividend.<\/li>\n\n\n\n
  • y<\/code> is the divisor.<\/li>\n<\/ul>\n\n\n\n
    The mod()<\/code> function returns the remainder when x is divided by y. If x and\/or y is NULL<\/code>, the mod()<\/code> function returns NULL<\/code>.<\/p>\n\n\n\n
    The mod()<\/code> function works like the %<\/code> operator except that it also works with the non-integers.<\/p>\n\n\n\n
    SQLite mod() function examples<\/h2>\n\n\n\n
    Let’s explore some examples of using the mod()<\/code> function.<\/p>\n\n\n\n
    1) Basic SQLite mod() function example<\/h3>\n\n\n\n
    The following example uses the mod()<\/code> function to get the remainder of 7 and 4:<\/p>\n\n\n
    SELECT<\/span> mod<\/span>(7<\/span>,4<\/span>) remainder<\/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
    remainder\n---------<\/span>\n3.0<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    As mentioned earlier, the mod()<\/code> function also works with non-integers:<\/p>\n\n\n
    SELECT<\/span> mod<\/span>(11.0<\/span>, 2.0<\/span>) remainder<\/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
    remainder\n---------<\/span>\n1.0<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    The following example uses the mod()<\/code> function with a negative dividend:<\/p>\n\n\n
    SELECT<\/span> mod<\/span>(-7<\/span>,2<\/span>) remainder<\/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
    remainder\n---------<\/span>\n-1.0<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    The following statement uses the mod()<\/code> function for both negative dividend and divisor:<\/p>\n\n\n
    SELECT<\/span> mod<\/span>(-7<\/span>,-2<\/span>) remainder<\/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
    remainder\n---------<\/span>\n-1.0<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    2) Using the mod() function to calculating the leap year<\/h3>\n\n\n\n
    The following example uses the mod()<\/code> function to check if 2024 is a leap year or not:<\/p>\n\n\n
    SELECT<\/span> mod<\/span>(2024<\/span>, 4<\/span>) = 0<\/span> and<\/span> (mod<\/span>(2024<\/span>, 100<\/span>) <> 0<\/span> or<\/span> mod<\/span>(2024<\/span>, 400<\/span>) = 0<\/span>) is_leap_year;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    Output:<\/p>\n\n\n
    is_leap_year\n------------<\/span>\n1<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    The output indicates that 2024 is the leap year. If it is not a leap year, the query will return 0 instead.<\/p>\n\n\n\n
    Please note that a year is a leap year if it is divisible by 4, but not by 100 unless it is also divisible by 400.<\/p>\n\n\n\n
    Summary<\/h2>\n\n\n\n
      \n
    • Use the mod()<\/code> function to get the remainder after dividing a number by another.<\/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