Skip to content

DAY

Return the day number (1 through 31) from a date or timestamp expression:

DAY(expression)

For example:

premdb=# select day(timestamp '11-30-2017 15:30:10.123456') from sys.const;
 day 
-----
  30
(1 row)

See also MONTH and YEAR.

Parent topic:Datetime Functions