afarun Posted February 19, 2009 Share Posted February 19, 2009 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] Quote Link to comment Share on other sites More sharing options...
galbus Posted March 19, 2009 Share Posted March 19, 2009 The query you are using looks suitable for a DATETIME field - can you switch the types from TIMESTAMP to DATETIME? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.