Thread: epoch <-> timestamp

epoch <-> timestamp

From

Patrick Welche

Date:

06 March 2001, 17:52:40

How can you get back to a timestamp from a number of seconds?

Re: epoch <-> timestamp

From

Bruno Wolff III

Date:

06 March 2001, 19:03:25

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'

Re: epoch <-> timestamp

From

Ben

Date:

12 March 2001, 18:12:16

select timestamp(983908507);

On Tue, 6 Mar 2001, Patrick Welche wrote:

> How can you get back to a timestamp from a number of seconds?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>

Re: Re: epoch <-> timestamp

From

Patrick Welche

Date:

12 March 2001, 18:32:35

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...