Re: Cast timestamptz to/from integer? - Mailing list pgsql-general

From Chris Angelico
Subject Re: Cast timestamptz to/from integer?
Date
Msg-id CAPTjJmrW-=jBM+zTxkhe81Wzy3d9mhGN7TsQcMxV7enbvpFHWA@mail.gmail.com
Whole thread Raw
In response to Re: Cast timestamptz to/from integer?  (Bartosz Dmytrak <bdmytrak@gmail.com>)
Responses Re: Cast timestamptz to/from integer?  (Bartosz Dmytrak <bdmytrak@gmail.com>)
List pgsql-general
On Tue, Apr 3, 2012 at 7:11 PM, Bartosz Dmytrak <bdmytrak@gmail.com> wrote:
> I think You can use epoch
> there is an
> example: http://www.postgresql.org/docs/9.1/static/functions-datetime.html
>
>
> SELECT TIMESTAMP WITH TIME ZONE 'epoch' + 982384720.12 * INTERVAL '1
> second';

Yep, but when you do that a lot, your statement gets extremely long. I
can create a function that'll hide the mess away, but what I'm hoping
to do is simply cast:

SELECT 982384720::timestamptz;

ChrisA

pgsql-general by date:

Previous
From: Bartosz Dmytrak
Date:
Subject: Re: Cast timestamptz to/from integer?
Next
From: Bartosz Dmytrak
Date:
Subject: Re: Cast timestamptz to/from integer?