GWicke added a comment.

In https://phabricator.wikimedia.org/T76373#943426, @Smalyshev wrote:

> Proposed storage format for dates:
>
> 1. Dates are stored as long signed integers, representing number of seconds 
> since 1970-01-01 00:00:00 UTC.
> 2. This gives us range of 292 bln years 
> <http://www.wolframalpha.com/input/?i=9223372036854775807+seconds+in+years>.
> 3. When parsing the date, if they year is below 292000000 (by absolute value) 
> we use Java functions, and hope they work right with the calendar, etc.
> 4. Beyond year 292M, we just count in whole years - i.e. the number stored is 
> years*SECONDS_IN_YEAR


We should double-check that this transition is actually monotonic. In doubt, we 
can use the timestamp for year 292M according to Java + (year - 292M) * 
SECONDS_IN_YEAR.


TASK DETAIL
  https://phabricator.wikimedia.org/T76373

REPLY HANDLER ACTIONS
  Reply to comment or attach files, or !close, !claim, !unsubscribe or !assign 
<username>.

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Smalyshev, GWicke
Cc: Smalyshev, Manybubbles, GWicke, JanZerebecki, aude, Lydia_Pintscher, 
Eloquence, aaron, jkroll, Wikidata-bugs, daniel



_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

Reply via email to