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

From Patrick Welche
Subject Re: Re: epoch <-> timestamp
Date
Msg-id 20010307104525.D15717@quartz.newn.cam.ac.uk
Whole thread Raw
In response to Re: epoch <-> timestamp  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
On Tue, Mar 06, 2001 at 03:15:19PM -0600, Bruno Wolff III wrote:
> 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'

Thanks all for the tips!

Patrick

> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

no I want to have mail sent to @cam, but send mail from @newn.cam - used
to work with pgsql-loopback...

pgsql-general by date:

Previous
From: Mathijs Brands
Date:
Subject: Re: [SQL] Re: Re: MySQLs Describe emulator!
Next
From: daniel
Date:
Subject: database access