rember241 Posted August 22, 2012 Share Posted August 22, 2012 hello guys, need help please.. i continued working on an existing information system but I came across that the datatype for myDATE is in VARCHAR, I'm having problems now on how will i filter dates, i want to change the datatype of field myDate from VARCHAR to DATE. I altered the datatype on my table but the results are bad. so please please help guys.. thanks you thank you thank you.. Quote Link to comment https://forums.phpfreaks.com/topic/267406-h-change-datatype-from-varchar-to-date-datatype-wout-value-not-changed/ Share on other sites More sharing options...
Pikachu2000 Posted August 22, 2012 Share Posted August 22, 2012 Never alter a field type like that, especially without backing up the data. Create a new field of the proper type, then run an UPDATE query to populate the new field with the properly formatted data from the old field. Once you've verified that the update was 100% successful, you can rename the fields and delete the old one if you want to. Quote Link to comment https://forums.phpfreaks.com/topic/267406-h-change-datatype-from-varchar-to-date-datatype-wout-value-not-changed/#findComment-1371413 Share on other sites More sharing options...
rember241 Posted August 23, 2012 Author Share Posted August 23, 2012 thank you sir for your answer, Quote Link to comment https://forums.phpfreaks.com/topic/267406-h-change-datatype-from-varchar-to-date-datatype-wout-value-not-changed/#findComment-1371713 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.