Postgres Pro
Downloads
Home   >   mailing lists

Re: conversion from epoch - Mailing list pgsql-general

From Steve Atkins
Subject Re: conversion from epoch
Date
Msg-id 4664D3A1-33AA-4F20-B346-B93BBC588543@blighty.com
Whole thread Raw
In response to conversion from epoch  ("Little, Douglas" <DOUGLAS.LITTLE@orbitz.com>)
List pgsql-general
Tree view 
On Jul 30, 2012, at 7:36 AM, Little, Douglas wrote:

> I have an input source that is in epoch time.    Is there a built-in conversion to changing to timestamp

to_timestamp().

You can also do things like "select timestamptz 'epoch' + ? * interval '1 second'".

Cheers,
  Steve

pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: conversion from epoch
Next
From: Vincent Veyron
Date:
Subject: Re: Debian upgrade with PostgreSQL