definative way to place secs from epoc into timestamp column

From: Bret Hughes <bhughes(at)elevating(dot)com>
To: postgresql sql list <pgsql-sql(at)postgresql(dot)org>
Subject: definative way to place secs from epoc into timestamp column
Date: 2005-03-02 16:25:17
Message-ID: 1109780719.28180.86.camel@bretsony
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I give up. I have STFW and STFM and still do not feel like I have a
good way to update/insert into a timestamp w/o TZ column with an integer
representing seconds from epoch. I am adding functionality to a php app
that does a fair amount of work with time and am currently using
abstime($timestamp). $timestamp is a php timestamp. I found this on the
web somewhere since I find no reference to a function abstime. There is
significant hits relating to abstime in the docs but it all seems to
refer to an internal data type of low res time data.

Help. I would really like to do this in the most efficient way possible
but would like it be not likely to break in future releases.

Bret

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message T E Schmitz 2005-03-02 16:42:43 Re: psql encoding problem
Previous Message Casey T. Deccio 2005-03-02 16:14:12 Re: table constraints