DAY

The DAY Function

Function Group: Date

DAY takes a date and returns an integer representing the day of the month on which it falls.

Syntax

DAY(arg1)

• arg1 is a date object or a function that resolves to a date object

Uses

Let's say we received a response with some insurance claim information:

{  
   "data":{  
      "claim": {
        "issue_number": "2a515",
        "date": "NOW()"
      }
   }
}

If we wanted to find the day of the month for the date field, which is set to the value of NOW, we could use DAY:

DAY(data.claim.date)

Which would return an integer with the day at the time of calling.

The structure of the date response returned follows the ISO 8601 standard.