Re: Trouble with UNIX TimeStamps

On Fri, 2002-12-27 at 05:49, Jonathan Chum wrote:

> The table column, ticket_starters.ticket_time_start is an INT type which
> contains a UNIX timestamp. I did not see anywhere in the Interactive docs
> how'd I convert the UNIX timestamp into a timestamp type so I can extract
> the day name. I'd rather not use PostGreSQL's timestamp types and just
> convert the database over to it since much of the programming utilizes the
> UNIX timestamp. Any ideas?

select 1041013653::int4::abstime;

will give you the timestamp from unixtime. If you just want the day, you
can use to_char like so:

select to_char(1041013653::int4::abstime,'dd');