Horton

Re: [HACKERS]

Patrick Welche <prlw1@newn.cam.ac.uk>

View thread View on postgr.es
From: Patrick Welche <prlw1@newn.cam.ac.uk>
To: gomathi raju <gomathi_raju@usa.net>
Cc: pgsql-novice@postgresql.org
Date: 2000-05-24T22:40:57Z
Lists: pgsql-hackers, pgsql-novice, pgsql-sql 
On Mon, Jun 30, 2036 at 10:05:43PM -0600, gomathi raju wrote:
> Hi friends,
> 
> 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.

Could this be what you want?

template1=# select CURRENT_TIMESTAMP;
       timestamp        
------------------------
 2000-05-24 23:40:19+01


Cheers,

Patrick