"Richard Huxton" <dev(at)archonet(dot)com> writes:
> Tom - I thought 'epoch'::timestamp should work too - good reason, or just
> One Of Those Things (tm)?
It works --- it's a symbolic value, though.
regression=# select 'epoch'::timestamp;
?column?
----------
epoch
(1 row)
regression=# select 'epoch'::timestamp + ('1 day'::interval);
?column?
------------------------
1970-01-01 19:00:00-05
(1 row)
Note the epoch is midnight GMT = 7pm local time here.
regards, tom lane