Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA64515 for ; Thu, 6 Apr 2000 16:55:58 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id QAA28759; Thu, 6 Apr 2000 16:54:07 -0400 (EDT) To: Ryan Bradetich cc: pgsql-sql@postgreSQL.org Subject: Re: Datetime as a time_t? In-reply-to: <38ECBAD4.E13DD27B@hp.com> References: <38ECBAD4.E13DD27B@hp.com> Comments: In-reply-to Ryan Bradetich message dated "Thu, 06 Apr 2000 10:27:00 -0600" Date: Thu, 06 Apr 2000 16:54:06 -0400 Message-ID: <28756.955054446@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200004/57 Ryan Bradetich writes: > Does anyone know how to extract a datetime field as a time_t? date_part('epoch', ...); Not exactly the first thing you'd think to try, but it works. regards, tom lane