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
- 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
- Introduced in EAV 1.0 2sxc 1.0