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 the output. Similarly for YEAR and DAY use the following commands

SELECT EXTRACT (YEAR FROM date);
SELECT EXTRACT (DAY FROM date);

But for HOUR MINUTE and SECONDS extractions, we can not use date command, we have to use time instead. To see time use the following command;

SELECT TIME;

This would return “15:59:19″ as the output and to extract HOUR MINUTE and SECONDS from this, use the following commands

SELECT EXTRACT (MINUTE FROM time);
SELECT EXTRACT (HOUR FROM time) ;
SELECT EXTRACT (SECOND FROM time) ;

If you use anything else than the expected inputs for the EXTRACT function you would end up getting 3707:  Syntax error.

Popularity: 63% [?]

Our Random Articles

• New Year Wishes 2010
• New Year Wishes
• How to Post on a Separate/New Page in WordPress
• Usage of Macro in Teradata
• Creating Column Aliases in Teradata

More Links