Received: from palrel1.hp.com (palrel1.hp.com [156.153.255.242]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA07082 for ; Thu, 6 Apr 2000 12:27:03 -0400 (EDT) (envelope-from ryan_bradetich@hp.com) Received: from hpbs4813.boi.hp.com (hpbs4813.boi.hp.com [15.56.8.57]) by palrel1.hp.com (Postfix) with ESMTP id 5B70D4FF for ; Thu, 6 Apr 2000 09:27:02 -0700 (PDT) Received: from hp.com (root@hpbs4813.boi.hp.com [15.56.8.57]) by hpbs4813.boi.hp.com (8.9.3 (PHNE_18979)/8.9.3 SMKit6.0.6 OpenMail) with ESMTP id KAA15970 for ; Thu, 6 Apr 2000 10:27:00 -0600 (MDT) Message-ID: <38ECBAD4.E13DD27B@hp.com> Date: Thu, 06 Apr 2000 10:27:00 -0600 From: Ryan Bradetich X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.14 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Datetime as a time_t? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200004/53 Hello, Does anyone know how to extract a datetime field as a time_t? My understanding is that PostgreSQL stores dates internally as a time_t, but I have not figured out how to extract them in that format. I have looked at the casting, and the set datestyles so far. Any ideas? Thanks, -Ryan P.S. I am using PostgreSQL 6.5.3