Thread: Current System Timestamp

Hi,
Exists in postgres a function that return me the current system timestamp?

For example:
INSERT INTO test VALUES (SYSDATE) \g

Thanks,
Pier Paolo.

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