"Richard Huxton" <dev@archonet.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