Delphi TmysqlQuery

[question]

sorry, i forgot to mention it is DateTime formate

Code:

query1.parambyname('newdate').AsDateTime := newdate /this formate i want 2013.09.05 17:00:00

[mkinzler]

A Windows/Delphi DateTime isn't formated ( it's a Double!). The machnism behind the Komponents should convert the Value into the coresponding fomat. ( Unfortunately mysql unlike other dbms stores string values in the format YYYY-MM-DD HH:MM:SS instead of the use of an independant format).

But as written before, your problem seems be different of this!