Posted by: Yi Ling
Date: September 21, 2004 07:39PM
when u specify something in DATE type... it will be YYYY-MM-DD
but, what in my .csv file is in MM/DD/YY format...
so, is there any "code" that can i help me change the default of DATE type in MySQL..
so, when i load the data into the database able to create it as DATE type instead of VARCHAR..
because i want to use the CURDATE() to calculate the year,month,day...
Thanks for any help...
P/S : if don't understand my question...please let me know! thanks =)
September 21, 2004 07:39PM
September 26, 2004 06:50AM
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.