Friday, March 26, 2010

Date Extract function of Oracle

select extract(day from date1) from table
select extract(month from date1) from table
select extract(year from date1) from table

No comments: