The date datatype is used to store dates.
Datatype identifier: ezdate
Look up the class attribute id in the admin interface ( setup > classes).
Use a timestamp convertor like the 4WebHelp Unix Timestamp Convertor.
Use the following SQL query. Replace 1192406400, 1197673200 and 247 with your own values.
UPDATE ezcontentobject_attribute SET data_int=1192406400, sort_key_int=1192406400 WHERE contentclassattribute_id=247 AND data_int=1197673200;
Article provided by eZpedia
All text is available under the terms of the GNU Free Documentation License
Powered by eZ Publish Community Project 4.2011
Hosted by Swiss eZ Publish partner YMC