Re: trunc year

On Oct 24, 1:00 am, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> <muhammaddzulkarn..._at_gmail.com> a écrit dans le message de news:
> e4851241-fa80-40ea-8052-9acb883a8..._at_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
>
> See answers to your question at:http://www.orafaq.com/forum/t/126566/102589/
>
> Regards
> Michel

i had tried your script just now. That was good. But now i have changed and i only want to display how to get year range between a previous year and current year (eg. previous year = 2007 and current year 2008) Received on Thu Oct 23 2008 - 23:17:10 CDT