palserv
asked on
how i can Split the date ?
Hello
i have an old Mysql Database that conatins the Data colums in that was store the date in one filed . i want to transfer all data to the new database that store the date as the day , month and year separat every one in unique column ..
how i can convart the old date to the new one ?
i have an old Mysql Database that conatins the Data colums in that was store the date in one filed . i want to transfer all data to the new database that store the date as the day , month and year separat every one in unique column ..
how i can convart the old date to the new one ?
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Can I ask you why you would want to do that?
I agree with Votey and Brandon -- if you can, stick with the standard MySQL date format of yyyy-mm-dd. You can always pick out Year, Month, Day when you need it, in exactly the way I showed above.
You will also be able to sort, use date ranges, and other selection functions MUCH more easily if you keep the standard format.
You will also be able to sort, use date ranges, and other selection functions MUCH more easily if you keep the standard format.
Plus, what would prevent the storage of 2008, 06, 40 as yyyy,mm,dd. You have no internal data validation.