Getting error in mssql database query - Date

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dibwas
    New Member
    • Apr 2010
    • 3

    Getting error in mssql database query - Date

    Code:
    SELECT COUNT(*) AS NumberOfRows FROM a_poll_votes 
    WHERE QUESTION_ID='1' 
    AND DATE_SUB(CURDATE(),INTERVAL 0 DAY) <= DATE_FORMAT(DT, '%Y-%m-%d') 
    AND IP='111.111.1.1'
    I think I am making mistake here:

    DATE_SUB(CURDAT E(),INTERVAL 0 DAY) <= DATE_FORMAT(DT, '%Y-%m-%d')

    Can anbody plz help me.

    This needs to be in asp and mssql

    Thanks
  • code green
    Recognized Expert Top Contributor
    • Mar 2007
    • 1726

    #2
    Well, you haven't posted the error, but this does look odd
    Code:
    DATE_SUB(CURDATE(),INTERVAL 0 DAY) <= DATE_FORMAT(DT, '%Y-%m-%d')
    This is not how date comparisons are done in SQL.
    What filter are you tying to apply here, and is DT a DATETIME data type field. Hopefuly yes

    Comment

    Working...