X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 3151C476348 for ; Tue, 15 Apr 2003 04:57:45 -0400 (EDT) Received: from shop.sme.sk (episoftware.casablanca.sk [217.11.230.150]) by postgresql.org (Postfix) with ESMTP id 57C1847631A for ; Tue, 15 Apr 2003 04:57:40 -0400 (EDT) Received: from [193.58.192.97] (helo=juice) by shop.sme.sk with esmtp (Exim 3.35 #1 (Debian)) id 195M4s-0007Zn-00 for ; Tue, 15 Apr 2003 10:46:07 +0200 Received: from localhost.localdomain ([192.168.1.25]) by juice for pgsql-sql@postgresql.org; Tue, 15 Apr 2003 10:57:14 +0200 Subject: atomatic insert date and time From: Rado Petrik To: pgsql-sql@postgresql.org Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 15 Apr 2003 10:58:48 +0200 Message-Id: <1050397128.992.41.camel@caj> Mime-Version: 1.0 X-Spam-Status: No, hits=-9.4 required=5.0 tests=BAYES_20,USER_AGENT_XIMIAN autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/221 X-Sequence-Number: 12922 Hi , I have column type "timestamptz". I need automatic add date and time when create new row. example. id | name | dt_created --------------------- INSERT INTO table (name) VALUES('test') id | name | dt_created ------------------------------- 1 test 1980-06-25 11:11-7 thanks. Rado.