EXTRACT
Extracts specified components from a given datetime.
Syntax
EXTRACT (unit FROM dateobj)
Arguments
dateobj: a valid date, datetime, time, or parsable date string
Return Type
Integer
Examples
SELECT EXTRACT(YEAR_MONTH FROM "2010-04-02 01:23:54");
+------------------------------------------------+ | EXTRACT(YEAR_MONTH FROM "2010-04-02 01:23:54") | +------------------------------------------------+ | 201004 | +------------------------------------------------+
SELECT EXTRACT(MICROSECOND FROM "2010-04-02 01:23:54.567");
+-----------------------------------------------------+ | EXTRACT(MICROSECOND FROM "2010-04-02 01:23:54.567") | +-----------------------------------------------------+ | 567000 | +-----------------------------------------------------+