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
>
>