oracle query

select ds.schedule_date,ds.start_hours||':'||ds.start_minutes||ds.start_ampm start_time,  
       ds.end_hours||':'||ds.end_minutes||'0'||ds.end_ampm end_time,
       first_name || ',' || mail_last_name new_name,
         ds.position,reason_code
from dept_staff ds, emp_unexcld eu
where ds.payroll_id = eu.payroll_id
and ds.schedule_date = '01-apr-2012'
order by schedule_date,ds.start_time,mail_last_name
-----------------------------------
SCHEDULE_DATE  START_TIME  END_TIME NEW_NAME           POSITION  REASON_CODE
4/1/2012        5:45A         2:00P  Barbara A,Ardelean   SRPM      SH
4/1/2012        5:45A         2:00P  Nichole S,Baines     PHMB      SH
4/1/2012        5:45A         2:00P  Thomas A,Cutter      TLMB      SH
4/1/2012        5:45A         2:00P  Adrian A,Fis         TLMB      SH
4/1/2012        5:45A         2:00P  Mandy,Lemke          PHMB      SH
4/1/2012        5:45A         2:00P  Nancy M,Penna        PHMB      SH
4/1/2012        5:45A         2:00P  Nyisha D,Richardson  SRPM      SH
-----------------In the Beginning I want Day - Sunday and then schedule_date, start_time
April 2nd is a Monday and I want Monday and then schedule_date
LVL 6
anumosesAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
Add it with to_char?

select to_char(ds.schedule_date,'Day'),ds.schedule_date,ds.start_hours||':'||ds.start_minutes

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
anumosesAuthor Commented:
I also want one more column end time minus start time as tot hrs (8.25)
slightwv (䄆 Netminder) Commented:
>>I also want one more column end time minus start time

That wasn't part of this question.

Anyway: so add it.  Isn't that the output from your previous question?  Just incorporate that logic into this query.  It should just be another column.
anumosesAuthor Commented:
thanks
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.