Ansolon
asked on
MYSQL VARCHAR(20) TO DATE TIME WITHOUT LOOSING DATA IN IT
Hi,
I am moving a data structure Varchar(20) to DATETIME. I did it before over 3 months ago and I remember simple phpmyadmin changing also changed date type and I see the real dates not 0000-00-00 00:00:00.
Here it is the structure information which I want to convert
Field: user_regdate
Type: VARCHAR
Lenght/Values: 20
Collation: utf8_unicode_ci
Attributes:
Null: not null
Default:
Extra:
Comment
And While we are browsing the date seems Feb 25, 2002
I want to convert this without loosing data are like "Feb 25, 2002" to DATETIME, for example 2002-02-25 00:00:00.
Thew new strcuture will be.
Field: user_regdate
Type: DATETIME
Lenght/Values:
Collation:
Attributes:
Null: not null
Default: 0000-00-00 00:00:00
Extra:
Comment
I am waiting for answer and solutions very thanks
I am moving a data structure Varchar(20) to DATETIME. I did it before over 3 months ago and I remember simple phpmyadmin changing also changed date type and I see the real dates not 0000-00-00 00:00:00.
Here it is the structure information which I want to convert
Field: user_regdate
Type: VARCHAR
Lenght/Values: 20
Collation: utf8_unicode_ci
Attributes:
Null: not null
Default:
Extra:
Comment
And While we are browsing the date seems Feb 25, 2002
I want to convert this without loosing data are like "Feb 25, 2002" to DATETIME, for example 2002-02-25 00:00:00.
Thew new strcuture will be.
Field: user_regdate
Type: DATETIME
Lenght/Values:
Collation:
Attributes:
Null: not null
Default: 0000-00-00 00:00:00
Extra:
Comment
I am waiting for answer and solutions very thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.