Date and time in the database

Date and time values are organized from the most to the least significant: year, month, day, hour, minute, second, and fraction of second.

​Each date and time value has a fixed number of digits that must be padded with leading zeros.

Representations can be done in one of two formats: a basic format with a minimal number of separators or an extended format with separators added to enhance human readability. The separator used between date values (year, month and day) is the hyphen, while the colon is used as the separator between time values (hours, minutes, and seconds).

​The time zone used in Symplify is Central European Time (CET).

Calendar dates

Symplify uses all-numeric data notation [yyyy]-[MM]-[dd]. A four-digit year [yyyy] is used to avoid the year 2000 problem. [MM] indicates a two-digit month of the year, 01 through 12. [dd] indicates a two-digit day of that month, 01 through 31.

For example, “the 5th of April 2016” is represented as “2016-04-05”.


Symplify uses the 24-hour clock system. The accepted format is [hh]:[mm]:[ss].

It is acceptable to omit lower order time elements for reduced accuracy.

​Date and time examples

2018-04-05 13:37

2019-12-11 20:00:00

Was this article helpful?
0 out of 0 found this helpful