Oracle takes week, month, quarter, and year start and end times

 1 Start time and end time of the fetch week

• The start time of the pick-up week. Start with Monday.

Sql>select TRUNC (to_date (' 2013-11-25 10:31:11 ', ' yyyy-mm-dd HH24:MI:SS '), ' D ') + 1 ASA from DUAL;

A

-----------

2013/11/25

• The end time of the fetch week. Ended in Sunday

Sql>select TRUNC (to_date (' 2013-11-25 10:31:11 ', ' yyyy-mm-dd HH24:MI:SS '), ' D ') + 7 ASA from DUAL;

A

-----------

2013/12/1

2 Start time and end time of the month are taken

• The start time of the month is taken

Sql>select TRUNC (to_date (' 2013-11-25 10:31:11 ', ' yyyy-mm-dd HH24:MI:SS '), ' MM ') as Afrom DUAL;

A

-----------

2013/11/1

• The end time of the month is taken

Sql>select Last_day (to_date (' 2013-11-25 10:31:11 ', ' yyyy-mm-dd HH24:MI:SS ')) as Afrom DUAL;

A

-----------

2013/11/30

3 Start time and end time of the season

• Start time of season

Sql>select TRUNC (to_date (' 2013-11-25 10:31:11 ', ' yyyy-mm-dd HH24:MI:SS '), ' Q ') as Afrom DUAL;

A

-----------

2013/10/1

• End time of the season

Sql>select add_months (TRUNC (to_date (' 2013-11-25 10:31:11 ', ' yyyy-mm-ddhh24:mi:ss '), ' Q '), 3)-1 as A from DUAL;

A

-----------

2013/12/31

4 Start time and end time of the year

• Start time of year

Sql>select TRUNC (to_date (' 2013-11-25 10:31:11 ', ' yyyy-mm-dd HH24:MI:SS '), ' YYYY ') ASA from DUAL;

A

-----------

2013/1/1

• The end time of the year is taken

Sql>select add_months (TRUNC (to_date (' 2013-11-25 10:31:11 ', ' yyyy-mm-ddhh24:mi:ss '), ' YYYY '), 1 as A from DUAL;

A

-----------

2013/12/31

Oracle takes week, month, quarter, and year start and end times