Re: Converting epoch to timestamp? - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Converting epoch to timestamp?
Date
Msg-id web-95041@davinci.ethosmedia.com
Whole thread Raw
In response to Re: Converting epoch to timestamp?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tom,

> regression=# select timestamp(996673954);
>        timestamp
> ------------------------
>  2001-08-01 09:52:34-04
> (1 row)
> 
> (This last didn't use to work, but it seems fine in 7.0 and 7.1.  It
> will fail in 2038 when timestamps stop looking like int4, but by then
> hopefully we'll have changed things...)

Yeah, sure.  That's what my father said in 1964 when they talked about
the potential problems with 2-digit dates on the UNIVAC II ...

;-)

-Josh


______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco
 


pgsql-sql by date:

Previous
From: "Michael Richards"
Date:
Subject: Exclusion List
Next
From: Tom Lane
Date:
Subject: Re: Exclusion List