Reading Foxpro database date field using PHP
- by Bill Yang
I've wrote a PHP script to export a Foxpro database to other formats by using ADODB (http://phplens.com/lens/adodb) library to access Foxpro OLE DB provider.
Everything worked fine except the date fields are mangled and become like these:
11/17-/2-00
3/4/-20-08
By comparing to actual data I can guess that it is probably in the format of MM/DD/YYYY or m/d/YYYY.
How can I properly export the date field?