SQL Reference Guide Built-in Functions Functions on Timestamps Timestamp extract functions Timestamp extract functions The timestamp extract functions allow you to fetch the date/week number/timestamp index from the input timestamps. The following sections describe these functions. year/month/day/hour/minute/second/millisecond/microsecond/nanosecond functions week/isoweek functions quarter/week/month/year index functions