Date

The date datatype is used to store dates.

Datatype identifier: ezdate

Replacing dates with SQL

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;

Related extensions

External resources