Date and quarter SQL ORACLE

sql oracle date to-date
Soji picture Soji · Jul 22, 2015 · Viewed 10.9k times · Source

I am currently working on oracle sql and have some issues managing dates and quarters.

The first thing I try to do is given a quarter and a year I would like to know the number of days of the quarter. For example, quarter 1 in 2013 had 90 days but in 2012 had 91 days.

The second thing I would like to do is convert a date dd/qq/yyyy to a date dd/mm/yyyy.

For instance, 60/2/2013 gives 30/5/2013. I am a beginner in Oracle so any help or function names will be highly appreciated.

Thanks

Answer

davegreen100 picture davegreen100 · Jul 22, 2015

this gives the number of days in the current quarter, playing around with the add_months should allow you to find the length of other quarters

select (add_months(trunc(sysdate,'q'),3) - 1) - trunc(sysdate,'q') 
from dual;

Related questions

Oracle: Avoiding NULL value in to_date

I have a functional select statement that has a where clause, in the where clause there is a statement like so... to_date(camp.start_date, 'MM/DD/YYYY') >= to_date(:from_date, 'YYYY-MM-DD HH24:MI:SS') However, if …

Read More
Updating a date in Oracle SQL table

I am trying to update a date in a SQL table. I am using Peoplesoft Oracle. When I run this query: Select ASOFDATE from PASOFDATE; I get 4/16/2012 I tried running this query UPDATE PASOFDATE SET ASOFDATE = '11/21/2012'; but it …

Read More
Check if current date is between two dates Oracle SQL

I would like to select 1 if current date falls between 2 dates through Oracle SQL. I wrote an SQL after reading through other questions. https://stackoverflow.com/questions/2369222/oracle-date-between-query https://stackoverflow.com/questions/2399753/select-from-table-by-knowing-only-date-without-time-oracle But it returned only null. sysdate is …

Read More