DBF to MySQL

CodeCharge Studio

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

DBF to MySQL

Author

Message

eZ Solutions

Posted: 07/09/2002, 2:01 PM

Hello,

I am exporting a DBF table into MySQL.
Can anyone help me to convert DBF datetime to MySQL datetime?

DBF displays 31/10/2000 3:17:16 PM but content shows
36830.6370.
36830 is Julian days from Dec 30, 1899 to 31/10/2000.
I cannot figure out how to convert 6370 to 3:17:16 PM.

TIA
Don

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home | Search | Members | Register | Login