Thread: Converting epoc number to timestamp

Just curious if there's a way in Postgres to take an epoch number (UTC)
which is stored as a bigint field and convert it to a timestamp.

perl does it like so:

$ perl -e 'print localtime(1020990264)."\n"'
Thu May  9 17:24:02 2002

Didn't see anything in the stored functions, but wanted to be sure.  If
not, would it make sense to create my own function that would do it in the
database or just code it on the front end (i.e. web app)?

 --
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Doug Silver
Network Manager
Urchin Corporation    http://www.urchin.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

On Fri, 2002-05-10 at 01:26, Doug Silver wrote:
> Just curious if there's a way in Postgres to take an epoch number (UTC)
> which is stored as a bigint field and convert it to a timestamp.
>
> perl does it like so:
>
> $ perl -e 'print localtime(1020990264)."\n"'
> Thu May  9 17:24:02 2002
>
> Didn't see anything in the stored functions, but wanted to be sure.  If
> not, would it make sense to create my own function that would do it in the
> database or just code it on the front end (i.e. web app)?

select 'epoch'::timestamp + '1020990264 seconds'::interval;
        ?column?
------------------------
 2002-05-10 01:24:24+01
(1 row)


--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "My son, do not despise the LORD's discipline and do
      not resent his rebuke, because the LORD disciplines
      those he loves, as a father the son he delights in."
                                       Proverbs 3:11,12

Is there a way to select rows randomly using weight columns? (weighted
random values)

Thanks,
Gerard


> -----Original Message-----
> From: pgsql-novice-owner@postgresql.org
> [mailto:pgsql-novice-owner@postgresql.org]On Behalf Of Doug Silver
> Sent: Thursday, May 09, 2002 6:26 PM
> To: pgsql-novice@postgresql.org
> Subject: [NOVICE] Converting epoc number to timestamp
>
>
> Just curious if there's a way in Postgres to take an epoch number (UTC)
> which is stored as a bigint field and convert it to a timestamp.
>
> perl does it like so:
>
> $ perl -e 'print localtime(1020990264)."\n"'
> Thu May  9 17:24:02 2002
>
> Didn't see anything in the stored functions, but wanted to be sure.  If
> not, would it make sense to create my own function that would do it in the
> database or just code it on the front end (i.e. web app)?
>
>  --
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Doug Silver
> Network Manager
> Urchin Corporation    http://www.urchin.com
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>