Re: inserting time_t into timestamp field(C language)

On Wed, Mar 17, 2004 at 11:29:10 +1100, Cal McPherson <calm@adtec.com.au> wrote:
> What is the most efficient way to convert a time_t struct so that I can
> insert it into a timestamp field.

Probably by converting to abstime and then to timestamp.
For example:
area=> select 1079497559::abstime::timestamp;     timestamp
---------------------2004-03-16 22:25:59
(1 row)