Received: from zwolle.execulink.net (zwolle.execulink.net [199.166.6.25]) by hub.org (8.9.3/8.9.3) with ESMTP id RAA72786 for ; Thu, 6 Apr 2000 17:50:00 -0400 (EDT) (envelope-from fbax@execulink.com) Received: from bax7 (ppp151.d2-2.56k.execulink.com [209.239.21.217]) by zwolle.execulink.net (8.10.0/8.10.0) with SMTP id e36Lnst26201 for ; Thu, 6 Apr 2000 17:49:54 -0400 Message-Id: <3.0.6.32.20000406175131.014ded10@execulink.com> X-Sender: fbax@execulink.com X-Mailer: QUALCOMM Windows Eudora Light Version 3.0.6 (32) Date: Thu, 06 Apr 2000 17:51:31 -0400 To: pgsql-sql@postgreSQL.org From: Frank Bax Subject: Re: Datetime as a time_t? In-Reply-To: <38ECBAD4.E13DD27B@hp.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Archive-Number: 200004/58 At 10:27 AM 4/06/00 -0600, Ryan Bradetich wrote: >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. abstime(datetime_field)::int8 works for both datetime and timestamp fields. Frank