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)
Parent topic:Datetime Functions
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)
Parent topic:Datetime Functions