afarun

Hi, I am trying to retrieve the records from the MS SQL Database through PHP script. Retrieving record between dates that is TIMESTAMP Field. Here are is my query: $sql= "SELECT EP_EPR.\"Create Date\",EP_EPR.\"EPR Number\", EP_EPR.\"EPR Owner\", EP_EPR.\"Logged by\" FROM \"EP:EPR\" EP_EPR WHERE (EP_EPR.\"Logged by\" = 'aganesan') AND (EP_EPR.\"Create Date\" >= '2/10/2009 04:19:41 PM')"; Create Date is the TIMESTAMP field on the database. i tried with many ways to retrieve the records, but i could not. i am struck.. Please help me how to retrieve the records from the database field "TIMESTAMP" . Have attached the screen shot and source code please check... Regards, Arun [attachment deleted by admin]