GoodName
asked on
Date EXTRACT() for hour, minute and second does not work
I have a problem of extracting time values from a date column.
I have no issues with year, month and a day though.
Sample: '6/20/2006 8:44:03 AM'
The TOAD error is:
ORA-30076: invalid extract field for extract source
I have no issues with year, month and a day though.
Sample: '6/20/2006 8:44:03 AM'
The TOAD error is:
ORA-30076: invalid extract field for extract source
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.