trunc year

#21

<muhammaddzulkarnain (AT) gmail (DOT) com> a écrit dans le message de news:
2649ff43-afda-45de-8508-7055f3a5dfa6...oglegroups.com...
On Oct 24, 1:00 am, "Michel Cadot" <micadot{at}altern{dot}org> wrote:

Quote:

muhammaddzulkarn... (AT) gmail (DOT) com> a écrit dans le message de news:
e4851241-fa80-40ea-8052-9acb883a8... (AT) d31g2000hsg (DOT) 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)

--------------------------------------

And then? The elements and functions are there in the examples and
documentation, don't you want to try it by yourself ?

Regards
Michel

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

trunc year

comp.databases.oracle.misc comp.databases.oracle.misc

Re: trunc year - 10-24-2008 , 11:06 AM