Re: trunc year
From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 23 Oct 2008 19:00:26 +0200
Message-ID: <4900adaa$0$10491$426a34cc@news.free.fr>
Date: Thu, 23 Oct 2008 19:00:26 +0200
Message-ID: <4900adaa$0$10491$426a34cc@news.free.fr>
<muhammaddzulkarnain_at_gmail.com> a écrit dans le message de news:
e4851241-fa80-40ea-8052-9acb883a8d85_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
Received on Thu Oct 23 2008 - 12:00:26 CDT