Using Extract function with any date field is easy. Let’s try this out with system date and system time commands. To see the current date we use SELECT DATE; This would give output as “11/06/2007″. Suppose you want to EXTRACT the month from the date then use this query SELECT EXTRACT (MONTH FROM date); This [...]