Received: from smtp015.mail.yahoo.com (smtp015.mail.yahoo.com
 [216.136.173.59])
	by postgresql.org (Postfix) with SMTP id 85F1C4758E6
	for <pgsql-sql@postgresql.org>; Thu,  4 Apr 2002 11:44:36 -0500 (EST)
Received: from psc.progress.com (HELO saturn.janwieck.net)
	(janwieck@192.233.92.200 with login)
	by smtp.mail.vip.sc5.yahoo.com with SMTP; 4 Apr 2002 16:44:33 -0000
Received: (from wieck@localhost)
	by saturn.janwieck.net (8.11.2/8.11.2) id g34GfMH07746;
	Thu, 4 Apr 2002 11:41:22 -0500
From: Jan Wieck <janwieck@yahoo.com>
Message-Id: <200204041641.g34GfMH07746@saturn.janwieck.net>
Subject: Re: Date
In-Reply-To: <004101c1dad6$474befe0$7201a8c0@dmhi.ct.ro> from cristi at "Apr
	3, 2002 09:10:39 am"
To: cristi <cristi@dmhi.ct.ro>
Date: Thu, 4 Apr 2002 11:41:22 -0500 (EST)
Cc: pgsql-sql@postgresql.org
X-Mailer: ELM [version 2.4ME+ PL68 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200204/56
X-Sequence-Number: 7321

Hi Cristi,

    "looking  for  a  Date" means something slightly different in
    the english language, and if your database is of the opposite
    gender, no wonder that it's a bit confused ;-)

    Never   mind,   could   you  give  us  a  bit  more  detailed
    information?  What's the PostgreSQL version and the output of
    "show datestyle"?


Jan

cristi wrote:
> I have o big problem!
> I have a table which has a field by date type.
> The date format is mm/dd/yyyy.
> When I'm doing this select:
> select da from a where da='03-31-2002';
> the result is :
> 03-30-2002
> 03-30-2002
> 03-30-2002
> I repet: only on '03-31-2002'!
>
> What's going on?
>
> Thanks in advance for any help.
>


--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #