Error in query: select count(*) as t from tbltwar where rdate='Tue 04/17/2012'. ERROR: invalid input syntax for type date: "Tue 04/17/2012" LINE 1: select count(*) as t from tbltwar where rdate='Tue 04/17/201... ^