Postgres Pro
Downloads
Home   >   mailing lists

Re: epoch <-> timestamp - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: epoch <-> timestamp
Date
Msg-id 20010306151519.A21988@wolff.to
Whole thread Raw
In response to epoch <-> timestamp  (Patrick Welche <prlw1@newn.cam.ac.uk>)
Responses Re: Re: epoch <-> timestamp  (Patrick Welche <prlw1@newn.cam.ac.uk>)
List pgsql-general
Tree view 
On Tue, Mar 06, 2001 at 12:00:53AM +0000,
  Patrick Welche <prlw1@newn.cam.ac.uk> wrote:
> How can you get back to a timestamp from a number of seconds?

I use this sequence in a perl program where $time is the current time in
seconds since the epoch.

timestamp 'epoch' + '$time second'

pgsql-general by date:

Previous
From: adb
Date:
Subject: Re: How robust is PostgreSQL
Next
From: gateley@jriver.com
Date:
Subject: DELETE and efficiency