On Wed, Oct 10, 2001 at 11:26:08AM +0200, Pier Paolo Bortone wrote:
> Hi,
> Exists in postgres a function that return me the current system timestamp?
>
> For example:
> INSERT INTO test VALUES (SYSDATE) \g
test=# SELECT now(), CURRENT_TIMESTAMP, 'now'::timestamp;
now | timestamp | ?column?
-----------------------+------------------------+------------------------
2001-10-10 11:36:14+02 | 2001-10-10 11:36:14+02 | 2001-10-10 11:36:14+02
(1 row)
Karel
--
Karel Zak <zakkr@zf.jcu.cz>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz