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 would give “11″ as [...]

Popularity: 63% [?]