am  23.05.2005, um 16:26:23 +0530 mailte [EMAIL PROTECTED] folgendes:
> 
> 
> 
> 
> 
> how can i extract the system date in postgress.

versand=# select now();
              now
-------------------------------
 2005-05-23 13:26:13.353826+02
(1 Zeile)

versand=# select CURRENT_DATE;
    date
------------
 2005-05-23
(1 Zeile)



Regards, Andreas
-- 
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    === 

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to