Results 1 to 3 of 3

Thread: Date issues

  1. #1
    Join Date
    Jan 2009
    Posts
    124

    Unanswered: Date issues

    In the past I have used the following query but now in 2010 is stopped working! Any clues?

    Nick

    SELECT
    key_esa
    , album_esa
    , image_esa
    , title_esa
    , sub_title_esa
    , body_esa
    , date_esa
    , order_esa
    , display_esa
    FROM essay
    WHERE display_esa =4
    And date_esa >= CURRENT_DATE - INTERVAL 120 DAY
    AND date_esa < CURRENT_DATE
    ORDER BY date_esa ASC

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by oldnickj View Post
    ... stopped working!
    plz give more information
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jan 2009
    Posts
    124

    My mistake

    The query works, i just didn't have any events fresher that 120 days!

Posting Permissions

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