::  Posts  ::  RSS  ::  ◂◂RSS  ::  Contact

Timestamp range in gnuplot

June 20th, 2011
gnuplot, tech  [html]

In gnuplot, you might have some data you'd like to graph that has timestamps:
     1308369601 0.15
     1308369661 0.05
     1308369721 0.43
     1308369781 0.41
     ...
  
You can see many places that to tell gnuplot your xaxis is in seconds since the epoch you use:
     set xdata time
     set timefmt "%s"
     set format x "%H:%M"     # or anything else
     set xlabel "time"
  
If you want to limit the range, you might think you could do something like:
     set xrange [1308369932:1308373241]
  
If you try this, you'll get an error like:
     "plot.gnp", line 16: all points y value undefined!
  
To fix this, you need to subtract 946684800 from the start and end of your xrange:
     set xrange [1308369932-946684800:1308373241-946684800]
  
What is going on here? It turns out that unlike everything sensible in the unix world, gnuplot calculates time in seconds since the beginning of the year 2000 instead of the year 1970. So it interprets [1308369932:1308373241] as early morning 2041-06-17 instead of early morning 2011-06-18. The magic number, 946684800, is the number of seconds between 2000-01-01 and 1970-01-01.

I understand gnuplot was trying to be platform independent, but it's pretty annoying now that the 1970 epoch has become dominant.

Recent posts on blogs I like:

High-Speed Rail in Small, Dense Countries

Four years ago I brought up the concept of the small, dense country to argue in favor of full electrification in Israel, Belgium, and the Netherlands. Right now I am going to dredge up this concept again, in the context of intercity trains. In a geographi…

via Pedestrian Observations October 12, 2019

What do executives do, anyway?

An executive with 8,000 indirect reports and 2000 hours of work in a year can afford to spend, at most, 15 minutes per year per person in their reporting hierarchy... even if they work on nothing else. That job seems impossible. How can anyone make any im…

via apenwarr September 29, 2019

Taxing investment income is complicated

How should a state tax investment income if it wants to maximize its citizens’ welfare? This sounds like a simple question but I find it surprisingly hard to think about. Here are some of the positions I’ve moved through over the last few years: Taxing in…

via The sideways view September 22, 2019

more     (via openring)

More Posts:


  ::  Posts  ::  RSS  ::  ◂◂RSS  ::  Contact