MySQL Forums
Forum List  »  Newbie

question about the date
Posted by: Yun Shen
Date: December 15, 2017 03:32PM

Hi,
I am a green hand of this software.
Now there is a dataset for me including information about date in a .csv file.
I input the file into the server with all variables of varchar types. The date variable appears to be '01JAN2013'. How can I convert it into '01/01/2013'? As I sort the order of date, the default initial is determined by the alphabet rather than the figure, so the minimum date in my dataset is '01APR2013' not '01JAN2013'. Or any other way to get the right order with date types of '01JAN2013'?

Options: ReplyQuote


Subject
Written By
Posted
question about the date
December 15, 2017 03:32PM
December 15, 2017 04:58PM


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.