Received: from web10008.mail.yahoo.com (web10008.mail.yahoo.com [216.136.130.44]) by postgresql.org (8.11.3/8.11.1) with SMTP id f4FJ4vA52565 for ; Tue, 15 May 2001 15:04:57 -0400 (EDT) (envelope-from jdearl@yahoo.com) Message-ID: <20010515190455.28860.qmail@web10008.mail.yahoo.com> Received: from [12.18.144.101] by web10008.mail.yahoo.com; Tue, 15 May 2001 12:04:55 PDT Date: Tue, 15 May 2001 12:04:55 -0700 (PDT) From: Jason Earl Subject: Re: system time To: Seema Noor , pgsql-sql@postgresql.org In-Reply-To: <20010515104609.9059.qmail@web3306.mail.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200105/151 X-Sequence-Number: 2968 Try using: SELECT now() It should do what you want. If not there are a whole pile of date functions. Look them up in the Users Guide. Hope this is helpful. Jason --- Seema Noor wrote: > is there any function from which i can get system > time? > > ____________________________________________________________ > Do You Yahoo!? > Get your free @yahoo.co.uk address at > http://mail.yahoo.co.uk > or your free @yahoo.ie address at > http://mail.yahoo.ie > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org __________________________________________________ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/