Received: from kahuna.versions.com (kahuna.versions.com [204.17.38.231]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5MI83a13358 for ; Fri, 22 Jun 2001 14:08:03 -0400 (EDT) (envelope-from pierre@kahuna.versions.com) Received: (qmail 18978 invoked by uid 502); 22 Jun 2001 18:08:01 -0000 Message-ID: <20010622180801.18977.qmail@kahuna.versions.com> From: pierre@kahuna.versions.com Date: 22 Jun 2001 11:08:01 -0700 Subject: timestamp conversion to unisgned long? To: pgsql-sql@postgresql.org Date: Fri, 22 Jun 101 11:08:01 -0700 (MST) Content-Type: text X-Archive-Number: 200106/386 X-Sequence-Number: 3682 All, Perhaps I'm not sing hte correct datatype, but I'd like to be able to convert a timestamp over to an unsigned long to be used within C code and compare to the output of time(). I can't seem to see any easy way of doing this using the built in stuff for postgresql. Ideas? Perhaps I'm using the wrong type? Pierre