Thread: need date clarification

how can i extract the system date in postgress.


Thanks & Regards
Palanivel P.K

Important Email Information :- The  information  in  this  email is
confidential and may  be  legally  privileged. It  is  intended  solely for
the addressee. Access to  this email  by anyone  else  is  unauthorized.  If
you are not the intended recipient, any disclosure, copying, distribution or
any action taken or omitted to be taken in reliance on it, is prohibited
and may be unlawful. If you are not the intended addressee please contact
the sender and dispose of this e-mail immediately.

am  23.05.2005, um 16:26:23 +0530 mailte palanivel.kumaran@scandent.com 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    ===