Results 1 to 4 of 4

Thread: how to find first day of week and first day of current week????

  1. #1
    Junior Member
    Join Date
    Nov 2008
    Answers
    1

    Exclamation how to find first day of week and first day of current week????

    how to find first day of week and first day of current week????


  2. #2
    Junior Member
    Join Date
    Jan 2007
    Answers
    7

    Re: how to find first day of week and first day of current week????

    Select next_day(sysdate-7, to_char(to_date('01-01-01','dd-mm-yy'),'day')) from dual;


  3. #3
    Expert Member
    Join Date
    Nov 2008
    Answers
    300

    Re: how to find first day of week and first day of current week????

    SELECT TRUNC(SYSDATE,'W') First_Day_of_current_Week,TO_CHAR(TRUNC(SYSDATE,'W'),'Day') First_Day_of_Week from dual


  4. #4
    Junior Member
    Join Date
    Jan 2016
    Answers
    1

    Re: how to find first day of week and first day of current week????

    Quote Originally Posted by gssharma_msc View Post
    Select next_day(sysdate-7, to_char(to_date('01-01-01','dd-mm-yy'),'day')) from dual;
    Thanks a TON!! It's not apparent from what others have mentioned. This one's perfect.


  5.  Sponsored Ads
    Ad


     

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact