Re: php, time and postgresql - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: php, time and postgresql
Date
Msg-id 20010112152941.A23518@wolff.to
Whole thread Raw
In response to php, time and postgresql  (Rasmus Resen Amossen <spunk@rhk.dk>)
List pgsql-general
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@rhk.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!

pgsql-general by date:

Previous
From: "Norman J. Clarke"
Date:
Subject: Re: SQL queries from within PL/PERL triggers?
Next
From: Alfred Perlstein
Date:
Subject: Re: FreeBSDers paying attention? (was Re: exit status 26)