DateTime query returning false values RRS feed

  • Question

  • SELECT *
    FROM tbl
    WHERE AND (day(field) BETWEEN 12 AND 13)
    AND (month(field) BETWEEN 7 AND 7)
    AND (year(field) BETWEEN 2010 AND 2010)

    if i execute this on sqlserver then i get correct values
    when i get data in my silverlight application to draw a chart then everything goes wrong. i only see a couple of time stamps which are also wrong
    i dont know where i am doing wrong...
    • Moved by Bob Beauchemin Monday, July 26, 2010 2:08 PM Moved to a hopefully more relevent forum (From:.NET Framework inside SQL Server)
    Monday, July 26, 2010 12:16 PM