Oracle Take week, month, quarter, year start and end time

1. Start time and end time of the week

Start time for the week, starting with Monday.

SELECT TRUNC (Date ' 2016-05-12 ', ' D ') + 1 from DUAL;

End time of the week, ending with Sunday

SELECT TRUNC (Date ' 2016-05-12 ', ' D ') + 7 from DUAL;

2. Start time and end time of the month

Start time of month

SELECT TRUNC (Date ' 2016-05-12 ', ' MM ') from DUAL;

End time of the month

SELECT last_day (date ' 2016-05-12 ') from DUAL;

3 start and end times of the season

Start time of the season

SELECT TRUNC (Date ' 2016-05-12 ', ' Q ') from DUAL;

End time of the season

SELECT add_months (TRUNC (date ' 2016-05-12 ', ' Q '), 3)-1 from DUAL;

4 Start time and end time of the year

Start time of the year

SELECT TRUNC (Date ' 2016-05-12 ', ' YYYY ') from DUAL;

End time of the year

SELECT add_months (TRUNC (date ' 2016-05-12 ', ' YYYY ')-1 from DUAL;