Oracle Database Discussions

Hi,

I want to extract the second value from sysdate using the EXTRACT function.
When i execute the following query i get an error ;

SELECT extract ( second FROM SYSDATE) FROM dual;

ORA-30076: invalid extract field for extract source.

When i do it to extract the month i get the proper result.

Is there some formatting needed in specifying the sysdate ( or any other date value) in the query. ?


Thanks.