Hi all,
I'm trying to retrieve data from Oracle through ODBC with PHP.
The script crashes when the statement odbc_fetch_row() is executed. This is after a query with odbc_exec($connect, $query) where the query string has a between clause "...between '27-NOV-00' and '31-DEC-00';". I have checked the format used by the database and it is indeed this format. WinSQL which is a gui ODBC front has no problems whith this date format.
I also tried Java servlets and Perl and they all seem to have this problem.
Any idea?
I'm trying to retrieve data from Oracle through ODBC with PHP.
The script crashes when the statement odbc_fetch_row() is executed. This is after a query with odbc_exec($connect, $query) where the query string has a between clause "...between '27-NOV-00' and '31-DEC-00';". I have checked the format used by the database and it is indeed this format. WinSQL which is a gui ODBC front has no problems whith this date format.
I also tried Java servlets and Perl and they all seem to have this problem.
Any idea?