Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2012
    Posts
    2

    Red face Unanswered: Missing scalar date functions (DB2 9.7)

    Greetings, dbForums![redacted]
    Deepest apologies! The version I am on is actually 9.5 and does not have functions like next_day() and last_day(). Please ignore this thread.
    Last edited by approved; 11-27-12 at 17:52. Reason: DB2 version info

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Are you sure you are on V9.7? It works on my 9.7 DB but not my 9.5. What is the output of db2level?


    Andy

  3. #3
    Join Date
    Nov 2012
    Posts
    2
    Quote Originally Posted by ARWinner View Post
    Are you sure you are on V9.7? It works on my 9.7 DB but not my 9.5. What is the output of db2level?


    Andy
    Yes, I've amended my top post. I am actually on v9.5. The confusion for me came from finding v8 docs on those functions, and figuring that my version must have had it. It appears though v9.7 for Windows is the earliest version with that functionality. I missed the v8 z/OS distinction there.

    Thank you for your reply.

Posting Permissions

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