15.4.2 Day(date)

day(date) function takes as an argument any one of the following data types: time interval or timestamp. The returned value represents the day in the timestamp represented by this date object. Returns a big integer indicating the day represented by this date.

Examples

Function Result

day(transaction-time), where transaction_time is 12/19/2016 12:22:48

19