pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedneed date clarification
2+ messages / 2 participants
[nested] [flat]
* need date clarification
@ 2005-05-23 10:56 palanivel.kumaran@scandent.com
0 siblings, 1 reply; 2+ messages in thread
From: palanivel.kumaran@scandent.com @ 2005-05-23 10:56 UTC (permalink / raw)
To: pgsql-sql
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [despammed] need date clarification
@ 2005-05-23 11:26 Andreas Kretschmer <akretschmer@despammed.com>
parent: palanivel.kumaran@scandent.com
0 siblings, 0 replies; 2+ messages in thread
From: Andreas Kretschmer @ 2005-05-23 11:26 UTC (permalink / raw)
To: pgsql-sql
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 ===
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-05-23 11:26 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-05-23 10:56 need date clarification palanivel.kumaran@scandent.com
2005-05-23 11:26 ` Andreas Kretschmer <akretschmer@despammed.com>
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