Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2006
    Posts
    55

    Unanswered: function dateadd

    hi,
    can something tell me what function do i need if i want to know what happen the last three hours?
    for example: dateadd (hh, -3, getdate())
    it seems not working?!!
    Peace out
    Mr joka

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    that works just fine

    perhaps remove the space between dateadd and (
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Oct 2006
    Posts
    55
    it was just a small mistake that i did not consider, now it's working, actually the space has nothing to do with it.
    thanks
    Peace out
    Mr joka

Posting Permissions

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