Questions about Mathematica's date and time functions.

learn more… | top users | synonyms (1)

2
votes
3answers
145 views

Delete rows based on specific periods

I have data (.xlsx format): two columns - data in first column imported as DateObject (dates with specific time), data in second column are numbers (113388.28, 865165.98 etc.). I want to delete the ...
4
votes
0answers
64 views

Is it possible to specify GMT as default in OpenSQLConnection or JDBC?

I'm connecting to a PostgreSQL database, with tables containing TIMESTAMPs with timezone, using ...
4
votes
0answers
86 views

JewishNewYear date limitation

The documentation for the function "JewishNewYear" in the "calendar" package declares that the year argument must be between 1900 and 2100. No explanation is given for this limitation. The function ...
3
votes
0answers
90 views

Behavior of TimelinePlot with multiple datasets of associations

The following TimelinePlot behaves as I would expect: ...
2
votes
0answers
49 views

Why are the labels twitching vertically in TimelinePlot?

Why are labels jumping up and down here: ...
2
votes
0answers
41 views

How can I set up a cell style that is ascending dates?

Outline style notebooks have cell counters that are simply ascending numbers, but what if I want to apply a function to them and have descending dates like this: So that they auto format and the ...
1
vote
0answers
40 views

DateObject from AbsoluteTime broken

In the middle of a session (10.0.2 / Win64 / 2.7Gb working set - peak was over 7Gb) the form/definition for DateObject from an integer has disappeared. ...
1
vote
0answers
27 views

Expose TimeObject fractions of a second and user-defined formatting

The default TimeObject formats (doc page), don't display fractions of seconds: ...
1
vote
0answers
107 views

How to create a complex variable from dated list values

Can anyone help me to construct a variable "PI" from values of variable x. Variable x represents a group of two time series rj and ri on equal dates(joined two dated lists with states).Variable x have ...
1
vote
0answers
61 views

Make a table of changes in US coinage

I thought of an innovative use of Mathematica/Alpha that I think Stephen Wolfram would really love, but I can't figure out how to get it to work. The idea is to make a table that would chart the ...
0
votes
0answers
35 views

Speeding up a “filling in” process

I have a sparse EventSeries that looks something like ...
0
votes
0answers
46 views

Improving semantic interpretation of dates

SemanticInterpretation and Interpreter are promising but imperfect, eg extracting dates and calendar expressions from ...