Re: set date format for column
Change the column under CUSTOM in Excel. Then save your CSV file and then Export it to MySQL.
how are you loading the file are you using LOAD DATA INFILE to do so? or are you importing via a GUI like PHPMYADMIN or Workbench?
---------------
Guelphdad,
Moderator
forums.mysql.com
Subject
Views
Written By
Posted
5730
August 03, 2011 02:09AM
2361
August 03, 2011 05:53AM
2018
August 03, 2011 09:31AM
2716
August 03, 2011 09:51AM
1872
August 03, 2011 11:48AM
1652
August 03, 2011 12:04PM
1875
August 03, 2011 12:23PM
1757
August 03, 2011 01:45PM
1779
August 04, 2011 11:55PM
1651
August 03, 2011 09:33AM
1700
August 03, 2011 09:43AM
1650
August 03, 2011 11:40AM
1706
August 03, 2011 01:47PM
Re: set date format for column
1790
August 03, 2011 01:01PM
1773
August 03, 2011 01:08PM
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.