Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    Regular Coder
    Join Date
    Jul 2006
    Posts
    124
    Thanks
    1
    Thanked 0 Times in 0 Posts

    What's the equivalent of INTERVAL on SQL Server 2005?


  • #2
    Regular Coder
    Join Date
    Aug 2006
    Location
    Richmond, CA
    Posts
    204
    Thanks
    3
    Thanked 11 Times in 10 Posts
    Quote Originally Posted by davidc2 View Post
    Uh... maybe you could tell us what you're trying to do? I'm not even sure what interval does.

  • #3
    Regular Coder
    Join Date
    Jul 2006
    Posts
    124
    Thanks
    1
    Thanked 0 Times in 0 Posts

    I need help with this SQL Query

    I got this working hehe
    here's what I had
    date '1993-07-01' + interval '3' month

    and I changed it to
    dateadd(month, 3, '1993-07-01')



    thanks for your help
    Last edited by davidc2; 05-03-2007 at 06:14 PM.


  •  

    Posting Permissions

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