Skip to main content
Version: 2023.3

Date Datatypes

Date, Date & Time

The date and date & time object fields are represented by a calender widget in the Pimcore GUI.

Date FieldDate FieldDate Field

In the database its data is saved as unix timestamp and thereby stored in an INT data column. Programmatically these data types are represented by a DateTime/Carbon Object.

Time

The time data field is the same drop down list of day times as in the date & time field.

Time FieldTime FieldTime Field

It's stored as a string in a VARCHAR(5) column in the database and can be set programmatically by simply passing a string like for example "11:00" to the field's setter.

Date Range

The dateRange object field consists of two date fields (start and end date) and can be filled with the usual calendar widget in the Pimcore GUI or programmatically via the Pimcore API.

Date Range FieldDate Range FieldDate Range Field

The two dates are stored as unix timestamps in two separate INT columns in the database. Programmatically the date range is represented by a CarbonPeriod Object.