Sorry for dont start my own topic... I apologize
Hi! No I haven't tested with the v5 driver yet, but I found out that the
problem is when I use date_format function
If I dont use it the data is returned ok in my app(but with hours, minutes
etc), but if i do a date_format i get "bytes" on each record instance of get
date formated, the column type is datetime(of my table)
De: Martijn Tonies [mailto:m.tonies@stripped]
Enviado el: Viernes, 10 de Febrero de 2006 12:51 p.m.
Para: 'Mysql '
Asunto: Re: MySQL 5.0.x and Delphi
First of all: you're sending a message with an enormous quote of someone
elses message, this really is "not done" on an e-mail list. Start your own
> I'm having problems upgrading my database from 4.0.x to 5.0.x,
> specially with date fields
> For example with 4.0.x I do: "select startDate from TEvent" and in my
> application it is displayed ok(managed with controls), but the same
> code, same odbc, same control in delphi, etc with mysql 5.0.x it
> displays: byte instance of the date storaged in my table
What datatype is being returned for this column if you try and use it in
Delphi with the ODBC driver?
Did you try the v5 driver already?
> My versions are:
> Delphi 5
> MySQL 5.0.18
> MySQL 4.0.26
Database Workbench - development tool for MySQL, and more! Upscene
Productions http://www.upscene.com My thoughts:
http://blog.upscene.com/martijn/ Database development questions? Check the
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1