Re: [HACKERS] - Mailing list pgsql-novice

From Patrick Welche
Subject Re: [HACKERS]
Date
Msg-id 20000524234057.A22396@quartz.newn.cam.ac.uk
Whole thread Raw
In response to  (gomathi raju <gomathi_raju@usa.net>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: gomathi raju
Date:
Subject:
Next
From: Chris Bitmead
Date:
Subject: Re: [HACKERS]