Cool way of getting the year, month or day


select
extract(year from sysdate) as year
, extract(month from sysdate) as month
, extract(day from sysdate) as day
from dual;

0 comments: