Data formats

Dates

Date created

The shooting date or creation of a document is expressed in MySQL format: YYYY-MM-DD hh:mm:ss.
For example 2008-02-11 15:34:01.

Publication date

Practically every publication date (article, photo, comment, ...) are expressed in UNIX timestamp, the number of seconds since 1 January 1970 GMT. It's the application responsibility to convert this into the user's time format.