If I needed the year, I would simply issue the following:
- select extract(YEAR from sysdate) from dual;
Or if I needed the month:
- select extract(MONTH from sysdate) from dual;
This function works with dates, timestamps and even the interval datatype.
A blog about different programming subjects, mainly Java, SQL and PL/SQL that will help address topics that I have found useful.
No comments:
Post a Comment