MySQL Forums
Forum List  »  Spanish

Advanced Search
New Topic

Wrong Field Type - VB6
Posted by: Luis Lezcano
Date: February 01, 2008 02:40PM

Hi. I'm using VB6, MyODBC 3.51 and MySQL 5.0.51.
When I execute a statement like

"SELECT DATE(datetimefield) AS Date1, TIME(datetimefield) AS Time1 FROM sometable"

I dont get the desired values for the second column. The "recordset.field(x).value" returns the current date and the result of the Time function. For example:
2008-02-01 08:12:06.

Any idea about waht to do?

Thanks in advance.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Wrong Field Type - VB6
3738
Luis Lezcano
February 01, 2008 02:40PM
Re: Wrong Field Type - VB6
1599
William Chiquito
February 01, 2008 09:10PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.