Re: [despammed] need date clarification

From: Andreas Kretschmer <akretschmer(at)despammed(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: [despammed] need date clarification
Date: 2005-05-23 11:26:54
Message-ID: 20050523112654.GF15889@webserv.wug-glas.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

am 23.05.2005, um 16:26:23 +0530 mailte palanivel(dot)kumaran(at)scandent(dot)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 ===

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Kretschmer 2005-05-23 11:41:40 Re: [despammed] Re: Need clarification
Previous Message KÖPFERL Robert 2005-05-23 11:04:30 Re: Need clarification