From: Bret Hughes <bhughes@elevating.com>
To: postgresql sql list <pgsql-sql@postgresql.org>
Subject: definative way to place secs from epoc into timestamp column
Date: 02 Mar 2005 10:25:17 -0600
Message-ID: <1109780719.28180.86.camel@bretsony> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bhughes@elevating.com
Subject: Re: definative way to place secs from epoc into timestamp column
In-Reply-To: <1109780719.28180.86.camel@bretsony>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox