MySQL Forums
Forum List  »  Connector/ODBC

Why can I only get date format when I call store procedure through ADO?
Posted by: 涛 何
Date: March 10, 2014 09:12PM

Hi!I have a question:
I declared a stored procedure in MySql database.It has three parameters:
StartTime: DateTime,
EndTime:DateTime,
ID:INT
In my client program(program_language is CBuilder,and access_method is ADO), I used odbc to access this store-procedure .when I looked up the log,I found that the parameter(type is DateTime) couldn't be converted correctly.for example:The client passed '2014-3-10 12:00:00', but in mysql,the parameter is '2014-3-10',If I changed the type from datetime to timestamp,the result is same.What happened?
Thanks!

Options: ReplyQuote


Subject
Written By
Posted
Why can I only get date format when I call store procedure through ADO?
March 10, 2014 09:12PM


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.