Questions about Mathematica's date and time functions.

learn more… | top users | synonyms (1)

2
votes
3answers
180 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 ...
2
votes
1answer
38 views

DateListPlot incorrect time zone

I'm trying to plot energy usage over time using datelistplot but the time zone on the ticks is wrong, data for 7pm shows as 3am The code: ...
9
votes
0answers
139 views

Behavior of TimelinePlot with multiple datasets of associations

Bug introduced in 10.1 and persisting through 10.2 or later The following TimelinePlot behaves as I would expect: ...
4
votes
0answers
45 views

TimelinePlot with Interval in Associations

Bug introduced in 10.2 This is related to a previous question I asked about TimelinePlot and multiple associations (Behavior of TimelinePlot with multiple ...
4
votes
0answers
91 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
88 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
55 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 ...
2
votes
0answers
61 views

Why are the labels twitching vertically in TimelinePlot?

Why are labels jumping up and down here: ...
1
vote
0answers
45 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
31 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
108 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
62 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
26 views

How to show different DateListPlots with a popupmenu with different plot parameters

I bumped into the following problem: I have a relatively large dataset (250k row,11col), imported in from an SQL database. The format of the data is {{year,m,d,h,m,s},value}. I have successfully ...
0
votes
0answers
37 views

Speeding up a “filling in” process

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

Improving semantic interpretation of dates

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