Questions about Mathematica's date and time functions.

learn more… | top users | synonyms (1)

-2
votes
0answers
35 views

Specifying temporal precision in DateRange

DateRange inserts undesirable precision: ...
4
votes
1answer
64 views

EasterSunday replacement in Mathematica 10

The Calendar package, now obsolete, had functionality for "special dates", in particular EasterSunday[]. The documentation says it's been subsumed into Wolfram ...
4
votes
0answers
50 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 ...
1
vote
1answer
34 views

How to convert a string representing date into a DateList expression?

How to convert a string representing date into a DateList expression? For example, how to turn "1/2/2000" into {2000,1,2} assuming American style, and {2000, 2, 1} assuming European style, ...
2
votes
0answers
34 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
2answers
99 views

How do I remove the quotation marks from each element of a list containing dates that I have import from excel?

I've been stuck in this problem for 1 week. I just want to make a graph (Log-Return vs time (in year, month, day)). The code is: ...
1
vote
1answer
118 views

Trace two DateListPlots?

I currently have two DateListPlots in the same graph, with two different y-axes. I downloaded the package "TwoAxisDateListPlot" to accomplish this with ease. Now I want to be able to trace both of the ...
3
votes
3answers
117 views

Get the complement date range

Suppose that I have a date range list drlist = {{"2015-01-01", "2015-01-05"}, {"2015-01-07", "2015-01-07"}, {"2015-01-12", "2015-01-23"}} ...
1
vote
1answer
43 views

Why does TimeSeriesShift is just adding a fixed number of days?

I'd like to shift all contents of a TimeSeries object by one month. By shifting Feb. 1st I would expect to receive Mar. 1st. However it's not the case for Mathematica: ...
4
votes
4answers
171 views

Extract Specific Dates from DateList

Hopefully this is an easy question but I couldn't find an easy answer anyway. Surely there is some simple way to splice this... I want to take a large datelist in the format of {{2014,12,31}, value} ...
5
votes
1answer
84 views

ChineseLunar calendar system mystery

I tried to make a custom holiday calendar for the Korean Stock Exchange. And I found that the built-in "ChineseLunar" calendar system gives me an awkward result. The code is ...
1
vote
1answer
78 views

Plotting CSV files with UTC Universal Time

So I have many CSV files in format like this: 2014-12-11T16:13:13.038337Z , 3.90092 2014-12-11T16:14:13.456558Z , 3.89734 2014-12-11T16:15:12.444318Z , 3.90092 I imported a CSV file ...
5
votes
2answers
96 views

How to speed up Min of DateObjects?

I'm in version 10.0.1 using a Dataset to do some plots and things. For one of the plots I need to get the minimum date of a some filtered set of the ...
4
votes
1answer
112 views

DateList does not output the correct time, but Date does

I noticed a strange thing when trying the new astronomical data functions in Mathematica 10 on my Raspberry Pi. The Sunrise and ...
2
votes
1answer
128 views

A possible bug with regard to DateObjects in Version 10?

Bug related to the Suggestion Bar Bug While getting used to the new data type Date Object in Version 10 I noted that there seems to be a bug which on my machine ...
14
votes
1answer
259 views

Is there a way to get AbsoluteTime to correctly report absolute time differences?

Absolute time supposedly reports the "total number of seconds" between two dates, but it does not. For example because of the leap second applied at 2012-06-30T23:59:60Z ...
9
votes
2answers
248 views

ScheduledTask with scoped variables. Working with timed evaluation

I guess I have to try harder and focus more but timed evaluation always frustrates me. I will show the issue on simple example of delayed trigger. ...
2
votes
4answers
171 views

How to remove hours, minutes, seconds from list

How to remove 0 that represent hours, minutes, and seconds from a date list say a ...
1
vote
1answer
51 views

DateListLogLogPlot

The command completion feature in Version 10.0.1.0 shows a command DateListLogLog but there is no documentation and doesn't work. Is this something that is going to be released in the near future and ...
3
votes
2answers
248 views

Should we invest in Apple?

Ticker[comp_String] := Interpreter["Company"][comp] /. Entity[_, x_] :> x ticks = Ticker /@ {"Apple", "Google"} {"NASDAQ:AAPL", "NASDAQ:GOOGL"} ...
1
vote
1answer
53 views

DayRound Rounding Values:No difference between “Preceding” and “Following”?

On Mathematica 10.0.1 both DayRound[{1980, 2, 29}, "EndOfMonth", "Preceding"] and ...
4
votes
2answers
76 views

How to sum values in the list that belongs to same week

I need to sum values that belongs to same week. For example, I have the list x with one column and n rows. Format: ...
1
vote
0answers
101 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
2answers
117 views

How to select states with equal times

Can anyone show me how to select the states that have equal times-dates. For example, i have two time series. First that have 10 observations, say from 2014/10/1 to 2014/10/10, and second that have 7 ...
5
votes
4answers
220 views

Change string date/time to be understandable for mathematica

I'm trying to convert a string of a data and time to be understandable for mathematica (I want to make time related plots). However, I can get my head around how to do this. For example: ...
13
votes
3answers
1k views

How do I compute sidereal time and JD?

There was once a package that provided a wide range of functions for computing astronomical information. This package now appears to be out of date; but as near as I can tell, many of the useful ...
2
votes
1answer
125 views

DateListPlot with multiple data sets and incongruous timelines?

I am using Mathematica to analyze some sales data for my company. (A copy of the available data is here.) We are trying to analyze the sales trends for each month by item. DateListPlot works well ...
6
votes
1answer
103 views

How to make several DateListPlot have the same scale?

I want to plot some weather data series. Unfortunately the series were collected in different episodes, from which some overlap. I would like to plot them as different plots in a column, but with ...
6
votes
5answers
385 views

Calendar view outline

How to compute the outline of a calendar month like this D3 example. (D3 is a functional language built on JavaScript developed at Stanford and used by New York Times to deploy interactive ...
0
votes
1answer
112 views

How to get an Excel-like surface plot with ListContourPlot3D

I'm trying to create an Excel like surface plot from an import of data from an Excel workbook. I get the data without issue. It is a set of percentages in bin ranges over a series of dates. I'd ...
1
vote
0answers
59 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 ...
8
votes
2answers
211 views

interpolating function over dates

I've got a bunch of readings at various dates and times. I'd like to be able to interpolate and then integrate over, say days. I can do this by converting my date/time to ...
7
votes
3answers
197 views

Timeline plotting: horizontal bars of time intervals

This text file logs the time that a process (identified by a number) changes state ("Brown", "Blue" etc.") ...
2
votes
1answer
75 views

Correct handling of milliseconds in a date time string

DateString[{2014, 5, 7, 13, 47, 44.760}, {"Year", "-", "Month", "-", "Day", " ", "Hour", ":", "Minute", ":", "Second", ".", "Millisecond"}] Returns ...
8
votes
5answers
220 views
7
votes
3answers
190 views

Different results with DateRange and LeapYearsQ in Mathematica 9 and 10

With Mathematica 9.0 for Mac OS X x86 (64-bit) (January 24, 2013) one could use DateRange[{2000}, {2010}, "Year"] to achive ...
1
vote
1answer
107 views

How to get matching starting dates for different `FinancialData` properties? [closed]

Why do the "Return" and "Volume" outputs of FinancialData differ? Consider the following ...
12
votes
4answers
341 views

Does Mathematica support importing ISO 8601 date strings?

Does Mathematica have a built-in function to convert ISO 8601 formatted date strings (e.g. 2012-01-04T00:00:00) to a date list? ISO 8601 strings come in a variety ...
8
votes
1answer
163 views

Bug in DateListPlot in Mathematica 10

Mentioned this already in an answer to a related question. DateListPlot in Mathematica 10 has a horrible bug: If two points have the same time coordinate, only one is plotted; the others are ignored. ...
8
votes
3answers
342 views

Does Mathematica have Month Range and Day range?

It is known that CharacterRange["a", "z"] gives list of characters from a to z. Does Mathematica have something similar for weekdays and months of the year? ...
1
vote
0answers
31 views

Updating values in a Dataset [duplicate]

I'm starting to work with datasets. They seem like a useful addition to Mathematica. However, there's one fairly major stumbling block I can't get over. How do I update data in a dataset? I have a ...
4
votes
3answers
172 views

How to get a list of days from July 4th to Oct 4th over a range of years

I'd like to create a list with days from the 4th of July to the 4th of October starting in July 1970 to the current date. I tried to use DateRange, but I'm a bit ...
0
votes
1answer
61 views

Export date with specified format

My problem is that I want use PGFplot in $\LaTeX$ to draw my graphs, which x axis is a date. Therefore the output file has to have one column "UTC time" (YYYY-MM-DD hh:mm:ss) and the second one is the ...
3
votes
2answers
111 views

Slow work of TimeSeriesWindow

I have financial data (list of time-values pairs). There are more than 13000 elements. ...
4
votes
1answer
89 views

Poor (network) performance of Interpreter[“Time”]

I was surprised to see that Interpreter requires external WR resources as this is not documented, at least not here. On a 3Ghz iMac, took ~half a minute to ...
1
vote
1answer
130 views

Addition and subtraction of TimeObjects in v10 [closed]

Documentation states that "TimeObject allows addition and subtraction of time quantities". I can see that subtraction is fine, (example from doc page) TimeObject[{16, 17, 21}] - TimeObject[{10, ...
3
votes
1answer
205 views

BarChart that lines up with dates in DateListPlot

I am trying to create a chart similar to the view offered by TradingChart, but with custom data not relating to finance. ...
7
votes
3answers
471 views
41
votes
1answer
1k views

How can I manipulate TemporalData?

Version 9 introduced TemporalData but, truth be told, the documentation doesn't suggest that one can do much with it. Many of us have probably assumed we'd be ...