Hello,

I am trying to upgrade wcddl v2 to v3
Getting a problem with db upgradation

When I upgrade the db it changed time_added of content to

0000-00-00 00:00:00


Here is the structure of old and new table fields

SQL code

ALTER TABLE wcddl_downloads CHANGE COLUMN dat time_added DATETIME NOT NULL;


Structure :


Column Type Collation

Old (v2) dat varchar(15) latin1_swedish_ci

New (v3) time_added datetime


Old table data sample :

1300330662
1300336559
1300338181


Please help me on this

I want the date of the content added only, time can be 00:00

Please provide me the exact sql code to apply

Thanks,
mann
mannNmeet Reviewed by mannNmeet on . V3 upgrade problem with Date/Time Hello, I am trying to upgrade wcddl v2 to v3 Getting a problem with db upgradation When I upgrade the db it changed time_added of content to 0000-00-00 00:00:00 Rating: 5