SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Wizard gold trophysilver trophybronze trophy dc dalton's Avatar
    Join Date
    Nov 2004
    Location
    Right behind you, watching, always watching.
    Posts
    5,431
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    DATEDIFF function does not exist

    Boy I'm batting a million with MySQL this week. This is my latest huh? moment:

    Code MySQL:
    SELECT review_rotation_rate, last_review_id, DATEDIFF(CURRENT_DATE, last_rotation_date) AS days FROM  featured_review_rotation

    Error: FUNCTION hunt.DATEDIFF does not exist


    Now I swore you could do this this way, is it me or what?

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,338
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    it's you

    that will work in 4.1.1 and up
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Wizard gold trophysilver trophybronze trophy dc dalton's Avatar
    Join Date
    Nov 2004
    Location
    Right behind you, watching, always watching.
    Posts
    5,431
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937 View Post
    it's you

    that will work in 4.1.1 and up
    Well then I'm really confused because I am using 5.0.33

  4. #4
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,338
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    i wish i were a DBA

    i'm not, and to be honest, i actually don't wish that, not in this lifetime or the next

    what i do in situations like this is reinstall
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  5. #5
    SitePoint Wizard gold trophysilver trophybronze trophy dc dalton's Avatar
    Join Date
    Nov 2004
    Location
    Right behind you, watching, always watching.
    Posts
    5,431
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937 View Post
    i wish i were a DBA

    i'm not, and to be honest, i actually don't wish that, not in this lifetime or the next

    what i do in situations like this is reinstall
    I'm starting to think MySQL is mad at me because I have been using Postgresql in all my projects lately


Bookmarks

Posting Permissions

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