Postgres Pro
Downloads
Home   >   mailing lists

Re: conversion from epoch - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: conversion from epoch
Date
Msg-id 238966508.69778.1343659485671.JavaMail.open-xchange@ox.ims-firmen.de
Whole thread Raw
In response to conversion from epoch  ("Little, Douglas" <DOUGLAS.LITTLE@orbitz.com>)
List pgsql-general
Tree view 



"Little, Douglas" <DOUGLAS.LITTLE@orbitz.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

pgsql-general by date:

Previous
From: "Little, Douglas"
Date:
Subject: conversion from epoch
Next
From: Steve Atkins
Date:
Subject: Re: conversion from epoch