Reading Foxpro database date field using PHP

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?

Answers


Sounds like a potential bug or you are missing a setting with the library you are using. I have used the Visual FoxPro OLEDB driver to pull data out of a VFP table with no problem with respect to date formats. VFP stores dates in its own format, but the OLE DB drive will produce those dates in the normal date formats.

Rick Schummer - VFP MVP


Need Your Help

How do I immediately load another page in JSP/Spring?

spring jsp search load immediate

I'm not very experienced in JSP. I have an application, which uses the Spring framework, that does a search. I show these results in a JSP page.

Haskell + Yesod: Separating insert logic using Persistent won't compile. Cannot figure out types

haskell yesod

I'm new to Haskell, coming from Scala. I like Haskell, but I feel like I'm fighting the type system when it comes to using persistent.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.