On Wed, Dec 03, 2003 at 05:59:25PM +1100, Gavin Sherry wrote:
> On Wed, 3 Dec 2003, Christopher Kings-Lynne wrote:
>
> >
> > > + SELECT 'epoch'::timestamp + '1070430858 seconds'::interval;
> > > + <lineannotation>Result: </lineannotation><computeroutput>2003-12-03 05:54:18</computeroutput>
> > > </screen>
> >
> > You could also go:
> >
> > SELECT '1070430858'::abstime;
> >
> > But your way is probably a bit more stable...dunno...
>
> template1=# SELECT '1070430858'::abstime;
> ERROR: invalid input syntax for type abstime: "1070430858"
>
> I agree its more stable :-). That's on HEAD.
>
> Gavin
I like "more stable." "Clearer" is good, too :) :)
Cheers,
D
--
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100 cell: +1 415 235 3778