Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004
    Posts
    17

    Unanswered: Equivalent 4 Oracle NEXT_DAY fn

    Haii Friends,
    Is there any equivalent for Oracle's NEXT_DAY function in sybase.I need it for the following query...


    SELECT NEXT_DAY( SYSDATE ,'THURSDAY') FROM DUAL;

    ur Help in this regard is really appreciated....


    Regards,
    Vicky
    Last edited by apvignesh; 11-08-04 at 10:00. Reason: Modification needed

  2. #2
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    What does NEXT_DAY do?
    Thanks,

    Matt

  3. #3
    Join Date
    Nov 2004
    Posts
    17
    Haii,
    NEXT_DAY function will give the Exact Date of Next occurance of the Given day...
    Eg: Here in the this query, NEXT_DAY( SYSDATE ,'THURSDAY') it will give 11-11-2004

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •