Madhuri

• Sep 17th, 2006

 

select hire_date, to_char(hire_date, 'day') as day from employees order by to_char(hire_date, 'd')

Divya

• Sep 20th, 2006

 

thanks Madhuri...

but the result i m getting is in the order from sun then mon till sat(sun to sat)..

but i want to order it from mon then tue till sun(mon to sun).

If possible, plzz tell me the query for that.

Hari

• Sep 22nd, 2006

 

hi divya! its simple. Note down the query.select to_char(hiredate,'day') from emp order by to_char(hiredate-1,'d')then u'll get d result as u like

Divya

• Sep 27th, 2006

 

Thanks Hari,

now i m getting the desired output...

shwetadubey

 Profile Answers by shwetadubey 

• Oct 6th, 2006

 

hi..m shweta ..

i m working in oracle too..

can we xchange our mail id's...if yes mail me at..shweta_m_dubey@yahoo.co.in

sushil

• Oct 9th, 2006

 

Hi dea

ur answer is a  bit wrong its because it thn give u the output as sun to sat and not mon to sun

rgds.

-Sushil

sushil

• Oct 9th, 2006

 

select to_char(hiredate,'day') from emp order by to_char(hiredate-1,'d')

deepak singh

• Nov 7th, 2006

 

if you want to accurate answare then you excu. this query...........................select TRUNC(SYSDATE) date, to_char(SYSDATE,'day') day from DUAL order by to_char(TRUNC(SYSDATE)-1,'d')

vamsee krishna

• Nov 10th, 2006

 

Hi Deepak,

Could you please explain how the trunc(hire_date) will make the difference when you used it in the to_char for getting only the day of the week.

Thanks in advance.

-Vamsee

Girish

• Nov 23rd, 2006

 

select name,hiredate,to_char(hiredate,'day') from emp order by to_char(hiredate,'day') asc;

glakshkar

 Profile Answers by glakshkar 

• Sep 23rd, 2007

 

This qry won't fail :)

select data.emp_name
         , data.hire_date
         , data.day_name
  from ( select name emp_name
                    , hiredate hire_date
                    , to_char(hiredate,'day') day_name
                    , decode(to_char(hiredate,'day') , 'Monday', 1
                                                                        , 'Tuesday', 2
                                                                        , 'Wednesday',3
                                                                        , 'Thursday',4
                                                                        , 'Friday',5
                                                                        , 'Saturday',6
                                                                        , 'Sunday',7) day_no
              from emp) data
order by data.day_no;

I hav not tested this query, as i m not having oracle installed on the PC from where i m replying but this should be perfect qry [:)]

ravi214u

 Profile Answers by ravi214u Questions by ravi214u

• Jan 28th, 2008

 

select to_char(sysdate,'day') from dual order by to_char(sysdate,'d')

hemant.agarwal03

 Profile 

• Feb 13th, 2008

 

It's amazing.. today I was searching something like this and got it.. thanks Hari..Divya and all Geek family members.......

Cheers...

Hemant

vishakha_jain81

 Profile Answers by vishakha_jain81 

• Aug 7th, 2008

 

select to_char(hire_date,'day'),hire_date from day  order by hire_date asc;

sagar0422

 Profile Answers by sagar0422 

• Jul 9th, 2009

 

SELECT ename, hiredate, to_char(hiredate, 'day') as day FROM emp ORDER BY to_char(TRUNC(HIREDATE)-1, 'd')

ashishkumar2403

 Profile Answers by ashishkumar2403 

• Jan 2nd, 2010

 

Just try this this will give you correct output.

select date_column,to_char(date_column,'dy') from table_name order by to_char(date_column,'d') desc;

This will give you the date_column and it's date in order of monday first then tue and what will come next and so on...

ashishkumar2403

 Profile Answers by ashishkumar2403 

• Mar 20th, 2010

 

select to_char(cal_date,'dy') from mittu.calender order by to_char(cal_date,'d') asc;

dj_dj_dj

 Profile Answers by dj_dj_dj 

• Mar 22nd, 2010

 

select to_char(hire_date, 'day')
from table_name
order by to_char(hire_date -1 ,'day');




Regards
Dharmendra Jaiswal

katgeektalk

 Profile Answers by katgeektalk 

• Aug 26th, 2010

 

select hiredate,  to_char(hiredate, 'Day')  "DAY OF THE WEEK"
from scott.emp
order by to_char(hiredate-1, 'D')