3

In what format are CCK dates stored? If it stores dates in the database using a timestamp string instead of a native MySQL datetime format, what implications does that have in regards to storing dates before the unix epoch? Would it mean that CCK date fields would not be able to store something happening in year 1939, for example?

4

Date module provides three different formats, read about them here: Difference between date, datetime, and datestamp

  • Vote up! That links to a nice thread here, while this page provides documentation about the difference between them. – amateur barista Mar 31 '11 at 22:25
0

Answering my last question based on @tim.plunkett links:

Would it mean that CCK date fields would not be able to store something happening in year 1939, for example?

It would depend on what format you chose for the storing the data of the CCK field. If you use Datestamp (Unix Timestamp), then no, you won't be able to store dates before the Unix epoch. If you need to do that, go for Date (ISO Date), or better Datetime, which represents stores data in MySQL's native date format, and allows to store dates before the Unix epoch.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.