Re: Cast timestamptz to/from integer?
| От | Bartosz Dmytrak |
|---|---|
| Тема | Re: Cast timestamptz to/from integer? |
| Дата | |
| Msg-id | CAD8_UcZXO16KHrL8LMyphwzsXCb31L3=dhjVHKNb_+QKvr-1aw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Cast timestamptz to/from integer? (Chris Angelico <rosuav@gmail.com>) |
| Список | pgsql-general |
There is a build in function which encapsulates that statement:
Regards,
Bartek
SELECT to_timestamp (982384720);
EXPLAIN ANALYZE shows:
Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.002..0.003 rows=1 loops=1)
so this looks cheap
Bartek
2012/4/3 Chris Angelico <rosuav@gmail.com>
On Tue, Apr 3, 2012 at 7:11 PM, Bartosz Dmytrak <bdmytrak@gmail.com> wrote:Yep, but when you do that a lot, your statement gets extremely long. I
> 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';
can create a function that'll hide the mess away, but what I'm hoping
to do is simply cast:
SELECT 982384720::timestamptz;
ChrisA
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления: