Hi
I hate to post the question here unrelated to JFreeChart
but I need some help with MySQL.
I have a few tables in a database Z, namely
table
a
b
c
In table a, the columns are
my_date - longtext
num - int(11)
eg:
mysql> select * from a;
+----------+------+------+
| my_date | x |
+------------------+------+
| 08/06/2002 | 1 |
| 08/07/2002 | 2 |
+----------+------+------+
2 rows in set (0.00 sec)
Tables b and c have the same table structure and data type format.
Q:
How do I convert 08/06/2002 to 2002-08-06 format
without having to reinput all my data from scratch ?
Any help is FULLY appreciated.
Thanks