Received: from mx99.openu.ac.il (arbel.openu.ac.il [147.233.32.4]) by hub.org (8.9.3/8.9.3) with ESMTP id FAA78957 for ; Wed, 4 Aug 1999 05:21:59 -0400 (EDT) (envelope-from herouth@oumail.openu.ac.il) Received: from talmon.openu.ac.il (talmon.openu.ac.il [147.233.32.11]) by mx99.openu.ac.il (Postfix) with ESMTP for id 0ECAE4B53D; Wed, 4 Aug 1999 12:21:57 +0300 (IDT) Received: from [147.233.159.109] (mac-herouth.pc.openu.ac.il) by talmon.openu.ac.il (Netscape Messaging Server 3.54) with ESMTP id AAA4BDB; Wed, 4 Aug 1999 12:25:23 +0300 X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: In-Reply-To: <37A7991B.35CDB969@flashmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Wed, 4 Aug 1999 12:22:53 +0300 To: Ramanika From: Herouth Maoz Subject: Re: [SQL] datetime sample code? Cc: pgsql-sql@postgreSQL.org At 04:36 +0300 on 04/08/1999, Ramanika wrote: > I am looking for sample datetime functions but could not find them in > the manuals. > I want to get the current datetime from the system and insert into a > table. > > I want to select out parts of datetime like hours only or time only or > date only. I know this must be possible I just need some examples. Look in the PostgreSQL user guide, page 41 (It's in chapter 5, functions). Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma