Postgres Pro
Downloads
Home   >   mailing lists

Re: [despammed] need date clarification - Mailing list pgsql-sql

From Andreas Kretschmer
Subject Re: [despammed] need date clarification
Date
Msg-id 20050523112654.GF15889@webserv.wug-glas.de
Whole thread Raw
In response to need date clarification  (palanivel.kumaran@scandent.com)
List pgsql-sql
Tree view 
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    ===

pgsql-sql by date:

Previous
From: palanivel.kumaran@scandent.com
Date:
Subject: Re: Need clarification
Next
From: Andreas Kretschmer
Date:
Subject: Re: [despammed] Re: Need clarification