pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
(no subject)
4+ messages / 4 participants
[nested] [flat]

* (no subject)
@ 2000-05-24 15:37 gomathi raju <gomathi_raju@usa.net>
  2000-05-24 22:40 ` Re: [HACKERS] Patrick Welche <prlw1@newn.cam.ac.uk>
  2000-05-25 00:02 ` Re: [HACKERS] Chris Bitmead <chrisb@nimrod.itg.telstra.com.au>
  2000-05-25 04:54 ` Re: [SQL] Michael A. Mayo <mmayo@mcauleybrooklyn.org>
  0 siblings, 3 replies; 4+ messages in thread

From: gomathi raju @ 2000-05-24 15:37 UTC (permalink / raw)
  To: pgsql-novice@postgresql.org

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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [HACKERS]
  2000-05-24 15:37 (no subject) gomathi raju <gomathi_raju@usa.net>
@ 2000-05-24 22:40 ` Patrick Welche <prlw1@newn.cam.ac.uk>
  2 siblings, 0 replies; 4+ messages in thread

From: Patrick Welche @ 2000-05-24 22:40 UTC (permalink / raw)
  To: gomathi raju <gomathi_raju@usa.net>; +Cc: pgsql-novice@postgresql.org

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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [HACKERS]
  2000-05-24 15:37 (no subject) gomathi raju <gomathi_raju@usa.net>
@ 2000-05-25 00:02 ` Chris Bitmead <chrisb@nimrod.itg.telstra.com.au>
  2 siblings, 0 replies; 4+ messages in thread

From: Chris Bitmead @ 2000-05-25 00:02 UTC (permalink / raw)
  To: gomathi raju <gomathi_raju@usa.net>; +Cc: pgsql-novice@postgresql.org

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'
?



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [SQL]
  2000-05-24 15:37 (no subject) gomathi raju <gomathi_raju@usa.net>
@ 2000-05-25 04:54 ` Michael A. Mayo <mmayo@mcauleybrooklyn.org>
  2 siblings, 0 replies; 4+ messages in thread

From: Michael A. Mayo @ 2000-05-25 04:54 UTC (permalink / raw)
  To: gomathi raju <gomathi_raju@usa.net>; pgsql-novice@postgresql.org

----- 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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2000-05-25 04:54 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-05-24 15:37  gomathi raju <gomathi_raju@usa.net>
2000-05-24 22:40 ` Re: [HACKERS] Patrick Welche <prlw1@newn.cam.ac.uk>
2000-05-25 00:02 ` Re: [HACKERS] Chris Bitmead <chrisb@nimrod.itg.telstra.com.au>
2000-05-25 04:54 ` Re: [SQL] Michael A. Mayo <mmayo@mcauleybrooklyn.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox