Re: difference between current_timestamp and now() in quotes - Mailing list pgsql-general

On Thursday 22 January 2009 10:04:05 am Alvaro Herrera wrote:
> Adrian Klaver escribió:
> > At least on 8.2  'now()' does not work either at least not in the way I
> > think you want. I get:
> >
> > test=# SELECT 'now()';
> >  ?column?
> > ----------
> >  now()
> > (1 row)
>
> alvherre=# select 'now()'::unknown::timestamptz;
>           timestamptz
> -------------------------------
>  2009-01-22 15:01:46.352979-03
> (1 fila)
>
>
> It even works if you use "text" instead of unknown.

I see my problem I was just doing a select. When I did an insert into a
timestamp field than the 'now()' form worked. Learn something new everyday :)

--
Adrian Klaver
aklaver@comcast.net