Re: Current System Timestamp

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: Pier Paolo Bortone <pierpaolo(dot)bortone(at)netengineering(dot)it>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Current System Timestamp
Date: 2001-10-10 09:38:21
Message-ID: 20011010113821.D29004@zf.jcu.cz
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/

C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Heaven 2001-10-10 10:53:21 pop3 server and Postgresql
Previous Message Pier Paolo Bortone 2001-10-10 09:26:08 Current System Timestamp