From Varchar to Date format

[jeeva]

hi frnds,

 

i am having one problem with mysql.Previously i have created one Date field as varchar format.Now i want change that field as date fromat and also the data should be there as date format whatever i have stored previously.

 

i tried to change this but i couldn't get it changed....

 

can i get this?

 

thanks in advance...

 

jeeva

[matthewhaworth]

MySQL forum, not this one.  Though you could take all the data out, apply the function strtodate() and enter it all in again.

[jitesh]

<?php

 

echo date("m-d-Y",strtotime("2007-05-10"));

 

?>

[matthewhaworth]

<?php

 

echo date("m-d-Y",strtotime("2007-05-10"));

 

?>

 

strtotime() rather, not date.. my error.

[jeeva]

many thanks for reply

 

i want to make changes in database itself i mean change the database field as Date format not through code

 

can i make like this?

[jitesh]

table : test1

field  : name

 

 

ALTER TABLE `test1` CHANGE `name` `name` DATE DEFAULT '0000-00-00' NOT NULL

[jeeva]

thanks jitesh.

but if i do that my previous data will be lost know?

[jitesh]

May be

 

Keep back-up and try.

[xyn]

what was your date format before?

what are you changin it to now?

[jeeva]

For jitesh:

        No its not working....

        its give the error like "Incorrect date value: '9-4-2007' for column 'ReqDate' at row 1"

 

For Xyn:

        Previously i have stored data as dd-mm-yyyy with Varchar datatype

        i want change the field as Date datatype without data lose

[jitesh]

Current data must be in this format

 

Y-m-d

 

"2006-12-01"

 

Otherwise need to flush and re-enter.

 

 

[jeeva]

ok i will go for re-enter the data. that is the only way i think...

 

many thanks guys....bye....