MySQL Forums
Forum List  »  MySQL for Excel

String to Date conversion
Posted by: Sajid Khan
Date: December 17, 2017 03:34AM

I need some help about Mysql query,

I have to convert the text format into date in mysql.

I have noticed in excel that we can convert the general format of text into date format,




for e.g:




General format: 43084

Date format : 15-12-2017(dd-mm-yyyy)







In above example, you can easily convert the general format into date format in excel.




So what happen with me, I have mistakenly inserted general format of date into MySQL without converting into date format.




Now I want how to convert that general format into date in MySQL. you can easily do this in excel but don't know how to convert in MySQL.




plz help me to do this in MySQL , I don't want to delete and reinsert the data into MySQL

Options: ReplyQuote


Subject
Views
Written By
Posted
String to Date conversion
1036
December 17, 2017 03:34AM
644
January 15, 2018 12:40PM


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.