Re: problem with date/time constants - Mailing list pgsql-sql

You must either do:
select now();

or

select 'now'::timestamp;

now() is a function that takes no arguments.

it is also a special value recognized by timestamp parser.


On Tue, 3 Jul 2001, datactrl wrote:

> Hi, 
> server:PostgreSQl 7.1
> why doesn't following statement work?
> "select now;"
> 
> THANK YOU!
> JACK LIU
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://www.postgresql.org/search.mpl
> 
>