How to create this date objects?

[system]

Hi how to create this date objects i am using Oracle 11i database

please help

Previous Year
Next Year
Week_Ending MDYYYY
Month Number
Next Year
Next Month
Next Quarter
This Week
Last Week
Next Week
12 months rolling - Dec 2009 to Nov 2010
Today (current week) to end of year
current month to end of year
current period start to end of year - period is week

---

Baba (BOB member since 2010-02-04)

[system]

Welcome to B:bob:B!

This post will help:

Oracle Relative Date Functions

Just thought I’d help people out by posting some as a quick reference Yesterday: trunc(sydate)-1 Today: trunc(sysdate) Start of Current Month: trunc(sysdate,'mm') End of Current Month: last_day(sysdate) Start of Previous Month: trunc((trunc(sysdate,'mm')-1),'mm') End of Previous Month: trunc(sysdate,'mm')-1 Start of Current Quarter: trunc(sysdate,'q') End of Current Quarter: add_months(trunc(sysdate,'q'),3)-1 Start of Previous Quarter: trunc(trunc(sysdate,'q')-1,'q') End of Previous Qu…

---

Marek Chladny (BOB member since 2003-11-27)

[system]

Welcome to B B!

Try here:-

http://www.oradev.com/oracle_date_functions.jsp

http://ugweb.cs.ualberta.ca/~c291/F06/tutorials/oracle-date.html

---

Mak 1 (BOB member since 2005-01-06)

[system]

Thanks Mak 1, Marek Chladny

---

Baba (BOB member since 2010-02-04)

[system]

How to calculate

12 months rolling - Dec 2009 to Nov 2010
Today (current week) to end of year
current month to end of year
current period start to end of year - period is week
Nbr of days between 2 dates

Please help with formulas

---

Baba (BOB member since 2010-02-04)

[system]

Baba, I’m not going to do these for you…:).

See here:-

http://www.psoug.org/reference/date_func.html

---

Mak 1 (BOB member since 2005-01-06)

[system]

Hi,

This should be easy, no?

@Baba

Nbr of days between 2 dates

date1 - date2

---

Marek Chladny (BOB member since 2003-11-27)

[system]

Sum(Cost) where trunc(DATE) BETWEEN trunc(to_date(@prompt(‘Enter Date:’,‘A’,’…,User:0),‘DD/MM/RR’),‘IW’) AND to_date(@prompt(‘Enter Date:’,‘A’,’…,User:0),‘DD/MM/RR’)

Whether this code is correct for current period start to end of year - period is week ?

---

Baba (BOB member since 2010-02-04)

[system]

Hi Baba,

It looks that you are new here on BOB. And perhaps new to BO and/or Oracle DB. That’s nothing wrong, we all started sometimes somewhere.

However, please note that this is not a spoon-feeding forum where you get answers and confirmations to all your basic questions. Please learn basics on your own by reading manuals, by hands-on experience, by reading posts on BOB… and then come here and surprise us with a technical problem or challenge that has never been asked before…

Good luck.

---

Marek Chladny (BOB member since 2003-11-27)