trunc year

From: <muhammaddzulkarnain_at_gmail.com>
Date: Thu, 23 Oct 2008 03:15:36 -0700 (PDT)
Message-ID: <e4851241-fa80-40ea-8052-9acb883a8d85@d31g2000hsg.googlegroups.com>

Below is to get date range between a month

SQL> select sysdate,

  2         trunc(add_months(sysdate,-1),'month') start_date,
  3         trunc(sysdate,'month')-1 end_date

  4 from dual;
SYSDATE START_DATE END_DATE
---------- ---------- ----------
21/10/2008 01/09/2008 30/09/2008

how to get date range between a year?

start_date = 20080101
end_date = 20081231 Received on Thu Oct 23 2008 - 05:15:36 CDT