Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Pulling data for current week Sat - Friday:

Avatar of Weller0123
Weller0123 asked on
Oracle Database
4 Comments1 Solution1129 ViewsLast Modified:
What would be the best way to show weely timesheet data?  Each ETNumber already has a built in timeslice.  So it's like b.date for that project.

I just need to show the data for the current week back through Saturday.  I'sn't there something built into the date fctn?

Date               Sat     Sun      Mon     Tue      Wed    Thu      Fri
ET Number     b.date  b.date  b.date  b.date  b.date  b.date  b.date  
ET Number     b.date  b.date  b.date  b.date  b.date  b.date  b.date  

I don't understand how you would get 7 different days in a single row.  The "b.date(-7)" part is where I don't get it.

Would it be something like?...
Select
ET_NUMBER,
b.date(-7)
b.date(-6)
b.date(-5)
b.date(-4)
b.date(-3)
b.date(-2)
b.date(-1)
from
xxx
Where
xxx


The first two days would actually come from the last week.

So I need last week's Sat and Sunday.
Then Monday thru Friday.

Thanks in Advance!
ASKER CERTIFIED SOLUTION
Avatar of NicksonKoh
NicksonKohFlag of Singapore image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answers