From: | Mark Lane <mlane(at)mynewthing(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Fwd: Re: php, time and postgresql |
Date: | 2001-01-12 23:04:53 |
Message-ID: | 0101121604530C.10836@mark |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
---------- Forwarded Message ----------
Subject: Re: [GENERAL] php, time and postgresql
Date: Fri, 12 Jan 2001 14:13:21 -0700
From: Mark Lane <mlane(at)mynewthing(dot)com>
To: Rasmus Resen Amossen <spunk(at)rhk(dot)dk>
On Friday 12 January 2001 14:03, you 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!
If you want to save time in that format just use an int4. All you have there
is an integer value so you will not need a special datatype. With datetime
information you only need a special datatypes when you storing information in
a form such as provided by timestamp.
Mark
-------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Warren Vanichuk | 2001-01-12 23:10:56 | Re: ODBC connect in ERWin |
Previous Message | Niral Trivedi | 2001-01-12 22:58:11 | ODBC connect in ERWin |