Built-in Functions → day

day() is a scalar date function that returns the day of the month from a date or timestamp.

Signature

day(date exp)

The following table illustrates the day() parameter:

ParameterDescription
date expexpression evaluating to date

Returns

int

Example

day(date("2001-12-24 23:55:12.000"))

This example returns 24.