More often than not, I've got some kind of data in a postgresql database that is somehow described by timestamps.

Simple test table like this:

create table testdata (
   id serial,
   d numeric,
   ts timestamp without time zone default now()
);

Using bash I'll populate it a bit with not too unrealistic …