Skip to content

DateTime

Columns of the DATETIME data type store a timestamp that is a number identifying a point in time. The number is stored as the number of milliseconds past since January 1, 1970 00:00:00 in the GMT0 timezone. When using the REST API, the server returns the values of this data type as timestamps - the same way as they are stored in the database. However, if your application uses any of the Backendless SDKs, our libraries perform the conversion of the timestamp into a native data type that represents a date/time value.

Backendless Console converts the timestamps into a human readable format:

datetimecolumn-console

By default console displays the date/time values of the DATETIME type in your local timezone. You can change the display mode to show the values in the UTC timezone with the following checkbox:

dates-in-utc