EXTRACT(unit FROM date)
You can do the same thing we just looked at by using the EXTRACT command, the format is as follows:
This would be any call to the database that results in a date type variable being returned