X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 58A21D1D2BA for ; Mon, 1 Mar 2004 21:18:24 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 04274-04 for ; Mon, 1 Mar 2004 17:18:10 -0400 (AST) Received: from ns1.turtle-entertainment.de (ns1.turtle-entertainment.de [193.41.200.20]) by svr1.postgresql.org (Postfix) with ESMTP id 785F1D1E964 for ; Mon, 1 Mar 2004 17:18:07 -0400 (AST) Received: from ip97.85.1311c-cud12k-02.ish.de ([62.143.85.97] helo=mail.office.turtle-entertainment.de) by ns1.turtle-entertainment.de with asmtp (Exim 3.22 #3 (Debian)) id 1AxunY-0006ek-00; Mon, 01 Mar 2004 22:18:00 +0100 Received: from p5084bc48.dip.t-dialin.net ([80.132.188.72] helo=turtle-entertainment.de) by mail.office.turtle-entertainment.de with asmtp (Exim 3.22 #7 (Debian)) id 1AxunX-00060d-00; Mon, 01 Mar 2004 22:18:00 +0100 Message-ID: <4043A82C.9090707@turtle-entertainment.de> Date: Mon, 01 Mar 2004 22:16:28 +0100 From: Bjoern Metzdorf User-Agent: Mozilla Thunderbird 0.5 (Windows/20040207) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Louie Kwan Cc: "Pgsql-Admin (E-mail)" Subject: Re: SYSDATE in PostgreSQL !? References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/10 X-Sequence-Number: 12580 Louie Kwan wrote: > If there is no SYSDATE defined in PostgreSQL , what can I do ? > > createTimeStamp DATE default (SYSDATE) Perhaps NOW() ist what you are looking for? createTimeStamp DATE default 'NOW()' Regards, Bjoern