X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 0850047580B for ; Mon, 17 Feb 2003 07:19:43 -0500 (EST) Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66]) by postgresql.org (Postfix) with ESMTP id 623E0475461 for ; Mon, 17 Feb 2003 07:19:42 -0500 (EST) Received: from klaster.net (pq197.krakow.cvx.ppp.tpnet.pl [213.76.41.197]) by serwer.skawsoft.com.pl (Postfix) with ESMTP id 3A5E62B885; Mon, 17 Feb 2003 13:10:54 +0100 (CET) Message-ID: <3E50D338.8000406@klaster.net> Date: Mon, 17 Feb 2003 13:19:04 +0100 From: Tomasz Myrta User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; PL; rv:1.1) Gecko/20020826 X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: "A.Bhuvaneswaran" Cc: pgsql-sql@postgresql.org Subject: Re: Special Date/Time Inputs References: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/369 X-Sequence-Number: 11767 A.Bhuvaneswaran wrote: > On Mon, 17 Feb 2003, Tomasz Myrta wrote: > > >>Hi >>How do you use Special Date/Time Inputs described in Table 5.14 >>(Postgresql documentation)? >>It looks like only now() works. When I try to select epoch() I get >>error, that such function doesn't exist. >> > > > Try, > > http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=functions-datetime.html > > regards, > bhuvaneswaran Sorry, I didn't notice James Pye's example on the bottom. Thanks. Tomasz Myrta