trunc year

#1

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

#2

<muhammaddzulkarnain (AT) gmail (DOT) com> wrote

Quote:

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
select

to_date(to_char(sysdate,'yyyy')||'0101','yyyymmdd' ),
to_date(to_char(sysdate,'yyyy')||'1231','yyyymmdd' ) from dual;
since the first day and the last day of a year are always the same month and
day.
If you want the whole year then (and not ending midnight of 12/31 then end
date

select
to_date(to_char(sysdate,'yyyy')||'0101','yyyymmdd' ),
to_date(to_char(sysdate+366,'yyyy'))||'0101','yyyy mmdd') from dual;

#3

<muhammaddzulkarnain (AT) gmail (DOT) com> wrote

Quote:

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
select

to_date(to_char(sysdate,'yyyy')||'0101','yyyymmdd' ),
to_date(to_char(sysdate,'yyyy')||'1231','yyyymmdd' ) from dual;
since the first day and the last day of a year are always the same month and
day.
If you want the whole year then (and not ending midnight of 12/31 then end
date

select
to_date(to_char(sysdate,'yyyy')||'0101','yyyymmdd' ),
to_date(to_char(sysdate+366,'yyyy'))||'0101','yyyy mmdd') from dual;

#4

<muhammaddzulkarnain (AT) gmail (DOT) com> wrote

Quote:

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
select

to_date(to_char(sysdate,'yyyy')||'0101','yyyymmdd' ),
to_date(to_char(sysdate,'yyyy')||'1231','yyyymmdd' ) from dual;
since the first day and the last day of a year are always the same month and
day.
If you want the whole year then (and not ending midnight of 12/31 then end
date

select
to_date(to_char(sysdate,'yyyy')||'0101','yyyymmdd' ),
to_date(to_char(sysdate+366,'yyyy'))||'0101','yyyy mmdd') from dual;

#5

<muhammaddzulkarnain (AT) gmail (DOT) com> wrote

Quote:

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
select

to_date(to_char(sysdate,'yyyy')||'0101','yyyymmdd' ),
to_date(to_char(sysdate,'yyyy')||'1231','yyyymmdd' ) from dual;
since the first day and the last day of a year are always the same month and
day.
If you want the whole year then (and not ending midnight of 12/31 then end
date

select
to_date(to_char(sysdate,'yyyy')||'0101','yyyymmdd' ),
to_date(to_char(sysdate+366,'yyyy'))||'0101','yyyy mmdd') from dual;

#6

On Thu, 23 Oct 2008 03:15:36 -0700 (PDT),
muhammaddzulkarnain (AT) gmail (DOT) com wrote:

Quote:

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

A year is 12 months. last_day(add_months..) should do it.
Those functions are documented in the SQL refernence manual under
'Date functions' please read it!!!

--

Sybrand Bakker
Senior Oracle DBA

#7

On Thu, 23 Oct 2008 03:15:36 -0700 (PDT),
muhammaddzulkarnain (AT) gmail (DOT) com wrote:

Quote:

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

A year is 12 months. last_day(add_months..) should do it.
Those functions are documented in the SQL refernence manual under
'Date functions' please read it!!!

--

Sybrand Bakker
Senior Oracle DBA

#8

On Thu, 23 Oct 2008 03:15:36 -0700 (PDT),
muhammaddzulkarnain (AT) gmail (DOT) com wrote:

Quote:

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

A year is 12 months. last_day(add_months..) should do it.
Those functions are documented in the SQL refernence manual under
'Date functions' please read it!!!

--

Sybrand Bakker
Senior Oracle DBA

#9

On Thu, 23 Oct 2008 03:15:36 -0700 (PDT),
muhammaddzulkarnain (AT) gmail (DOT) com wrote:

Quote:

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

A year is 12 months. last_day(add_months..) should do it.
Those functions are documented in the SQL refernence manual under
'Date functions' please read it!!!

--

Sybrand Bakker
Senior Oracle DBA

#10

<muhammaddzulkarnain (AT) gmail (DOT) com> a écrit dans le message de news:
e4851241-fa80-40ea-8052-9acb883a8d85...oglegroups.com...

Quote:

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