Welcome! Log In Create A New Profile

Advanced

MYSQL Access via ODBC - Date Format

Posted by Scott.pcs.crosspost 
Forum List Message List New Topic
Scott.pcs.crosspost
MYSQL Access via ODBC - Date Format
May 01, 2009 07:22PM
I am accessing a MYSQL database for the first time using Windev, via ODBC. The date fields in the MYSQL tables seem to be very large numeric values - I assume hundredth seconds from a given date or the like. Does anyone know how I convert such a value to Date (dd/mm/ccyy) and time (hh:mm:ss) format for reporting?

Regards,
Scott

Message forwarded from pcsoft.us.windev
Reply Quote
Scott.pcs.crosspost
Re: MYSQL Access via ODBC - Date Format
May 02, 2009 03:58PM
I should have added that I tried using integertodate and a few other options, but could not get correct results. An example value is: 1175541670 which I think is on or about April 2007.

Regards,
Scott


Message forwarded from pcsoft.us.windev
Reply Quote
issah
Re: MYSQL Access via ODBC - Date Format
May 04, 2009 12:42PM
Hello,

Have you considered using the MySQL Native Access which is free. I have used MySQL extensively with WD but never with ODBC. The conversion of MySQL date fields to WD using Native access is transparent.

Regards

issah
Reply Quote
Newer Topic Older Topic
Author:

Your Email:


Subject:
Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: