14 Replies Latest reply: Mar 16, 2013 5:18 AM by Kaushik Solanki RSS

    How to give where condition on date in SQL



      I am loading the data from a VIEW which is created in SQL but WHERE condition is not working.  




      SELECT * FROM NEWC."VIW_MONTHLY" WHERE CALLDATE>='01/01/2013 00:00:00';

      condition is not working im getting all 2010 data also. Kindly help me...