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
Subject
Views
Written By
Posted
String to Date conversion
1182
December 17, 2017 03:34AM
759
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.