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 akla...@comcast.net -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general