Table of Contents

Field Data Type: DateTime

This explains DateTime Fields. For an overview check out Understanding Data....


DateTime data is a basic data type and is used for dates and/or time values.

Features

The basic datetime field doesn't have any features, since all the features are in the sub-types.

Sub-Types of DateTime Fields

  1. datetime-default - simple date and/or time input field (basic datepicker and/or timepicker)

Shared Settings

Don't have shared settings.


Technical Information

Storage in the SQL Database in the EAV-Model

This is converted to a string when stored as a string in the DB, and converted back to a .net DateTime when the data is loaded.

Storage in the SQL Database in the JSON-Model

This is stored as a string-value in json using the standard ISO format, as there is no official format for dates or times in JSON.

Null Value Possible

In some cases you may add a field to a type which already has Entities created previously. In this case the old data doesn't have a value for the field. If this happens, the field will return null, so you may need to catch this special exception in your code.

History

  1. Introduced in EAV 1.0 2sxc 1.0