15.4.11 Year(date)

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

Examples

Function Result

year(12/06/17 09:15:22 AM)

17

year(2015:07:21 12:45:35 PM)

2015