Shortened story:
I am developing a system which automates the creation of zencart tables into an offline database using MS Access. Tables are created and populated fine with the exception of the fields in tables which use the following date format: 0001-01-01 00:00:00
Ms Access does not like this format for many reasons so I need to change it. But this format is used by the zencart installer when creating the tables so if I changed it how would Zencart cope?
The most sensible option at my disposal will be to use Now() to set the date and time in MSAccess. This will set the current date and time in the format 01/01/2001 00:00:00. When my system exports this as a mysql dump file the code looks like:
date_added DATETIME NOT NULL DEFAULT Now(),
Will zencart work with this or will it introduce bugs?
Bookmarks