Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2009
    Location
    Locked in side a tiny room with a keyboard and many monitors glowing away in the dark...
    Posts
    25

    Unanswered: Date Comparisons

    Hi Gurus,

    I need to generate a report that compares a static date (say a contract end date) to the system date and have a report generated giving 1 month, 3 month and 6 month expiration warnings.

    Can anyone point me to a tutorial that can help me learn how to create a stored procedure for this?

    Thank you in advance!!
    Torchwood
    "understand, in a sick and twisted sort of way?"

  2. #2
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    I think that this may be a good start:
    Date and Time Data Types and Functions (Transact-SQL)
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  3. #3
    Join Date
    Jul 2009
    Location
    Locked in side a tiny room with a keyboard and many monitors glowing away in the dark...
    Posts
    25
    Thank you Florin, that is a great place to start!
    Torchwood
    "understand, in a sick and twisted sort of way?"

Posting Permissions

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