Re: conversion from epoch

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: "PostgreSQL General (pgsql-general(at)postgresql(dot)org)" <pgsql-general(at)postgresql(dot)org>, "Little, Douglas" <DOUGLAS(dot)LITTLE(at)orbitz(dot)com>
Subject: Re: conversion from epoch
Date: 2012-07-30 14:44:45
Message-ID: 238966508.69778.1343659485671.JavaMail.open-xchange@ox.ims-firmen.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Little, Douglas" <DOUGLAS(dot)LITTLE(at)orbitz(dot)com> hat am 30. Juli 2012 um 16:36
geschrieben:

> I have an input source that is in epoch time. Is there a built-in
> conversion to changing to timestamp
>
>
>
select 'epoch'::date + <your epoch-value> * '1second'::interval;

Andreas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Atkins 2012-07-30 14:51:26 Re: conversion from epoch
Previous Message Little, Douglas 2012-07-30 14:36:52 conversion from epoch