Skip site navigation (1) Skip section navigation (2)

Re: Trouble with UNIX TimeStamps

From: Ben <bench(at)silentmedia(dot)com>
To: jchum(at)aismedia(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Trouble with UNIX TimeStamps
Date: 2002-12-27 18:32:29
Message-ID: 1041013949.13070.328.camel@purple (view raw, whole thread or download thread mbox)
Lists: pgsql-general
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');

In response to

pgsql-general by date

Next:From: Tom LaneDate: 2002-12-27 18:39:58
Subject: Re: Trouble with UNIX TimeStamps
Previous:From: Payal RathodDate: 2002-12-27 17:33:42
Subject: Re: readline

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group