How about doing something like this:
bruno=> select 'epoch'::timestamp + '979333398 second';
?column?
------------------------
2001-01-12 15:03:18-06
On Fri, Jan 12, 2001 at 10:03:54PM +0100,
Rasmus Resen Amossen <spunk(at)rhk(dot)dk> wrote:
> I want to save some time information in postgresql with php. What is the
> datatype in postgresql coresponding to the mktime()-unixtime function in
> php (creates a time in the format "979333398" eg.)?
>
> Thanx!