Re: conversion from epoch

From: Steve Atkins <steve(at)blighty(dot)com>
To: "PostgreSQL General (pgsql-general(at)postgresql(dot)org)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: conversion from epoch
Date: 2012-07-30 14:51:26
Message-ID: 4664D3A1-33AA-4F20-B346-B93BBC588543@blighty.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vincent Veyron 2012-07-30 19:58:38 Re: Debian upgrade with PostgreSQL
Previous Message Andreas Kretschmer 2012-07-30 14:44:45 Re: conversion from epoch