DateTime field: Difference between revisions

Jump to navigation Jump to search
m
no edit summary
mNo edit summary
mNo edit summary
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Stamp|2017-02-07|4.2.1|1.0.8}}
{{Stamp|2018-09-27|4.5.5|1.1.0}}


A DateTime field may contain a value that is used to represent a particular calendar date and time — specifically, the value stored is the same as that used by Unix and Linux systems to represent dates, which is the number of seconds since January 1, 1970. Moments in time prior to that are negative numbers.
A DateTime field may contain any date of the Gregorian calendar and the time of day.
 
When a DateTime field's value is used in a Calculation field, the value used is that used by Unix and Linux systems to represent dates & times, which is the number of seconds before or since January 1, 1970. When a DateTime field's value is used in a JavaScript field or in Memento scripts, the value used is based on that used by Unix and Linux systems to represent dates & times, but is in milliseconds (instead of seconds) before or since January 1, 1970. Moments in time prior to that are negative numbers.


This value allows date/time arithmetic to work readily, by merely doing integer arithmetic with the value.
This value allows date/time arithmetic to work readily, by merely doing integer arithmetic with the value.
Line 23: Line 25:


{{FieldRequired}}
{{FieldRequired}}
{{FieldDataValidationBase}}


== Display Options ==
== Display Options ==

Navigation menu