The function extract computes a part of a date value. Its first argument gives the desired date part; the second argument is the date value. For instance, to obtain the year part of the appt date attribute of the table EMPHIST we write:
The function extract computes a part of a date value. Its first argument gives the desired date part; the second argument is the date value. For instance, to obtain the year part of the appt date attribute of the table EMPHIST we write: