manish singh wrote:
> iam using 4.0.17
>
> ok
> josh let me ask you something about data
> transformation i mentioned before
>
> taking the date field, if you transform the date
> from mm/dd/yyyy to yyyy-mm-dd
> and put it inside the mysql table why do you get
> 0000-00-00?
>
Assuming you were talking about an INSERT method where
you have created a batch of insert statements to run ...
I would think that this would look like 12/12/2000 which
sets up a division if you access the code.
mysql> select 12/12/2004;
+------------+
| 12/12/2004 |
+------------+
| 0.0005 |
+------------+
So when MySQL converts this to a date type, it is no surprise to me
that something like .0005 becomes a 0.
-------
If this is a LOAD DATA INFILE scenario, then I would suggest reading
this page very carefully about how to use it and represent data precisely:
http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
Regards,
Josh
Josh Chamas
Director, Professional Services
MySQL Inc., www.mysql.com
Get More with MySQL!
http://www.mysql.com/consulting