On Tue, Aug 13, 2002 at 11:32:25AM +0800, Christopher Kings-Lynne wrote:
> Is the int4 a UNIX epoch? ie. seconds since 1970?
>
> If so, then this will generally work:
>
> SELECT CAST(int4field AS abstime);
>
> or
>
> SELECT int4field::abstime;
http://www.postgresql.org/idocs/index.php?datatype-datetime.html says:
The types abstime and reltime are lower precision types which are usedinternally. You are discouraged from using any
ofthese types in newapplications and are encouraged to move any old ones over whenappropriate. Any or all of these
internaltypes might disappear in afuture release.
Don't they?
--
Fduch M. Pravking