posted 15 years ago
Hi,
use EXCTRACT conversion function, it extracts months and years as numbers,
it is available starting from Oracle 9i:
Also avoid using TIMESTAMP as a column name, TIMESTAMP is a data type,
it could cause confusion and Oracle can give you strange syntax errors in some cases.
But if you must, enclose it in brackets - like this- "TIMESTAMP".