Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • Change Column data-type from VARCHAR to DATE

    @uday.gangwar
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 268
    Comment on it

    Hello friends,

    I am here for share the solution of a MySQL problem. If you want to change the data type of a column from varchar or any other one to date, you should need to use following query-

    UPDATE `tbl` SET `date1` = STR_TO_DATE(`date1`, '%d-%m-%Y') WHERE 1=1

    For example if you have a table 'user' and a column 'dob' and the values in this column with the data type 'varchar' and pattern '29/MAY/15' and you want to change the column in to 'DATE'. You should need to use following query - 

    UPDATE `user` SET `dob` = STR_TO_DATE(`dob`, '%d/%M/%y') WHERE 1=1

    .

    change date data type mysql column change datatype of a mysql table column
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: