SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Extract (datatime)

390020Jun 23 2003 — edited Jun 24 2003

Hi, i'm working with 9i.
I try "Select extract(hour from datacolumn) ..." from a date field and it keeps telling me "ORA-30076 invalid extract field for extract source". However it's an obvious and self-explain error i cannot find the way to solve it. At first i try with an "alter session set nls_date_format='dd/mm/yyyy hh24:mi:ss'" but it was useless. i'm running out of ideas right now. can anyone give an advice on this?
Thanxs a lot.-

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 22 2003

Added on Jun 23 2003

8 comments

4,182 views