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.

Regards,
gomathi

____________________________________________________________________
Get free email and a permanent address at http://www.netaddress.com/?N=1

24 May 00 15:37:27 MDT
gomathi raju <gomathi_raju@usa.net>
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

Wed, 24 May 2000 23:40:57 +0100
Patrick Welche <prlw1@newn.cam.ac.uk>
Re: [HACKERS]
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.

Are you talking about 
SELECT 'now'
?

Thu, 25 May 2000 10:02:37 +1000
Chris Bitmead <chrisb@nimrod.itg.telstra.com.au>
Re: [HACKERS]
----- 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


Thu, 25 May 2000 00:54:38 -0400
"Michael A. Mayo" <mmayo@mcauleybrooklyn.org>
Re: [SQL] 