Re: [SQL] - Mailing list pgsql-novice

From Michael A. Mayo
Subject Re: [SQL]
Date
Msg-id 004a01bfc666$04f51e40$1ce8b798@362197428
Whole thread Raw
In response to  (gomathi raju <gomathi_raju@usa.net>)
List pgsql-novice
----- Original Message -----
From: "gomathi raju" <gomathi_raju@usa.net>
> I want to get the system timestamp from postgresql database.
> But I dont have a dual table from where ,I can select it.
> Give me a solution, from which table(system) I can get it.

No need to get it from a system table; it is available as a sort of "global
constant," current_timestamp.

Use it like this:

SELECT CURRENT_TIMESTAMP;

See the book at: http://www.postgresql.org/docs/awbook.html for more
information.

                -Mike


pgsql-novice by date:

Previous
From: "Gerhard Dieringer"
Date:
Subject: Antw: [SQL]
Next
From: "Javier Castro"
Date:
Subject: hello