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] Link to comment https://forums.phpfreaks.com/topic/145931-php-query-to-mssql-timestamp-field/ 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? Link to comment https://forums.phpfreaks.com/topic/145931-php-query-to-mssql-timestamp-field/#findComment-788395 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.