eZpedia : The Free eZ Publish CMS Documentation Encyclopedia

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

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