X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2383BD1B534 for ; Wed, 17 Mar 2004 00:46:19 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 00481-04 for ; Tue, 16 Mar 2004 20:46:20 -0400 (AST) Received: from server.adtec.com.au (237.005.dsl.syd.iprimus.net.au [210.50.51.237]) by svr1.postgresql.org (Postfix) with ESMTP id 6EAD9D1B4C8 for ; Tue, 16 Mar 2004 20:46:15 -0400 (AST) Received: by SERVER with Internet Mail Service (5.5.2653.19) id ; Wed, 17 Mar 2004 11:29:10 +1100 Message-ID: <65ED19764468D411A6AF006094EA0F3B275D73@SERVER> From: Cal McPherson To: "'pgsql-interfaces@postgresql.org'" Subject: inserting time_t into timestamp field(C language) Date: Wed, 17 Mar 2004 11:29:10 +1100 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/15 X-Sequence-Number: 4794 What is the most efficient way to convert a time_t struct so that I can insert it into a timestamp field. Cal McPherson Software Engineer ADTEC Communications Phone: +612 9213 9917 Fax: +612 9281 7575 Email: calm@adtec.com.au Web: www.adtec.com.au