Received: from mail.xmission.com (mail.xmission.com [198.60.22.22]) by hub.org (8.9.3/8.9.3) with ESMTP id EAA71635 for ; Wed, 4 Aug 1999 04:38:05 -0400 (EDT) (envelope-from ramanika@flashmail.com) Received: from [166.70.7.124] (helo=flashmail.com) by mail.xmission.com with esmtp (Exim 2.12 #1) id 11BwYm-00056a-00 for pgsql-sql@postgresql.org; Wed, 4 Aug 1999 02:38:05 -0600 Message-ID: <37A7991B.35CDB969@flashmail.com> Date: Wed, 04 Aug 1999 02:36:27 +0100 From: Ramanika X-Mailer: Mozilla 4.61 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: datetime sample code? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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. thanks ramanika