Return-Path: owner-postman Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id JAA01831 for postgres-dist; Thu, 11 Nov 1993 09:32:15 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199311111732.JAA01831@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from toe.CS.Berkeley.EDU (toe.CS.Berkeley.EDU [128.32.149.117]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with ESMTP id JAA01821 for ; Thu, 11 Nov 1993 09:32:14 -0800 Received: from cs.uml.edu (cs.uml.edu [129.63.1.11]) by toe.CS.Berkeley.EDU (8.6.4/8.1B) with SMTP id JAA01647; Thu, 11 Nov 1993 09:32:13 -0800 Received: by cs.uml.edu id AA06165 (5.67a+/IDA-1.5 for postgres@toe.cs.berkeley.edu); Thu, 11 Nov 1993 12:32:12 -0500 From: John Peter Lee Message-Id: <199311111732.AA06165@cs.uml.edu> Subject: time types To: postgres@toe.CS.Berkeley.EDU Date: Thu, 11 Nov 1993 12:32:11 -0500 (EST) X-Mailer: ELM [version 2.4 PL22] Content-Type: text Content-Length: 745 Resent-To: postgres-dist@postgres.Berkeley.EDU Resent-Date: Thu, 11 Nov 93 09:32:15 -0800 Resent-XMts: smtp Hi: I'm running Postgres 4.0.1, and want to use the built-in "time" type for some temporal data I have. I'm not sure from the docs as to how the time parameters are formatted into the libPQ calls. Are they to be input as strings, like so: absolute time "Jan 01 1993" time ranges: "[Jan 01 1990, Dec 31 1992]" or another way ? thanks in advance. jp ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ JP Lee Institute for Visualization and Perception Research jlee@cs.uml.edu University of Massachusetts at Lowell (508) 934-3384 1 University Ave. Lowell, MA 01854 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~