Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2005
    Posts
    127

    Question Unanswered: Date arithmetic operations..

    is there any DATE arithmetic functions to add or subtract days to a date(TIMESTAMP) variable or column.

    regards
    Sn

  2. #2
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    Code:
    select current date + 5 days, current timestamp - 5 days
    from sysibm.sysdummy1;
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  3. #3
    Join Date
    Dec 2005
    Posts
    273
    yes, if the column is a DATE or TIMESTAMP simply code:

    SELECT column-name + 1 DAY
    FROM ...


    or
    SET column-name = CURRENT DATE + 1 MONTH ...

  4. #4
    Join Date
    Apr 2005
    Posts
    127
    Wim , Umayer thanks for the help, it works fine now
    Last edited by Shefu; 02-01-06 at 08:48.

Posting Permissions

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