Greetings,
I need some mySQL assistance updating the date created column in the leads table.
Configuration Details:
lamp install running mySQL 4.1.21
php version 4.4.2
apache version 1.3.34
sugar 4.5f
Issue:
Date created missing after importing leads.
Analysis:
The date created in the file I imported from was in this format mm-dd-yyyy hh:mm
Apparently sugar is looking for (seconds) mm-dd-yyyy hh:mm:ss
The file I imported from was generated by exporting to csv from sugar 4.2f.
Request:
I have the old database with the correct mm-dd-yyyy hh:mm:ss values for date created (leads table). How can I update the date created values in the new leads table? I am sure there is mySQL query to handle this. Any mySQL Demigods up for the challenge?
-Cyjax


LinkBack URL
About LinkBacks



Reply With Quote
Bookmarks