Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-29976

Dates/Datetimes after 01/19/2038 @ 4:14am (UTC) can't be stored

    XMLWordPrintable

Details

    Description

      Due to MySQL int Integer Type limitation, the biggest timestamp that can be stored is 2147487247 which is 01/19/2038 @ 4:14 am (UTC).

      Trying to store later date/datetime will result in 500 exception.

      Steps to reproduce
      1. Create new Content Type with the date field.
      2. Create a new content object from said Content Type, set the date to 2050-01-01 and publish it.

      Result
      HTTP 500 Internal Server Error
      Database error

      Attachments

        Activity

          People

            Unassigned Unassigned
            mateusz.bieniek@ibexa.co Mateusz Bieniek
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated: