Re: Extracting date from epoche - Mailing list pgsql-sql

From Richard Huxton
Subject Re: Extracting date from epoche
Date
Msg-id 004901c0fa7a$329d5620$1001a8c0@archonet.com
Whole thread Raw
In response to Extracting date from epoche  (Najm Hashmi <najm@flipr.com>)
List pgsql-sql
From: "Tom Lane" <tgl@sss.pgh.pa.us>

> "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)

Ah - problem is in my wetware then. That's ok.

- Richard Huxton



pgsql-sql by date:

Previous
From: Roberto Mello
Date:
Subject: Re: Changing PL/pgSQL triggers
Next
From: Tom Lane
Date:
Subject: Re: Correct syntex for implicit curor in for loops