Received: from dmhi.ct.ro (dmhi.ct.ro [193.226.151.66])
	by postgresql.org (Postfix) with ESMTP id EA3A9475968
	for <pgsql-sql@postgresql.org>; Wed,  3 Apr 2002 01:12:04 -0500 (EST)
Received: from [192.168.1.114] (helo=aaa.dmhi.ct.ro)
	by dmhi.ct.ro with smtp (Exim 3.03 #1) id 16se0n-0005Ig-00
	for pgsql-sql@postgresql.org; Wed, 03 Apr 2002 09:12:49 +0300
Message-ID: <004101c1dad6$474befe0$7201a8c0@dmhi.ct.ro>
From: "cristi" <cristi@dmhi.ct.ro>
To: <pgsql-sql@postgresql.org>
Subject: Date
Date: Wed, 3 Apr 2002 09:10:39 +0300
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_003E_01C1DAEF.6C885F00"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
X-Archive-Number: 200204/51
X-Sequence-Number: 7316

This is a multi-part message in MIME format.

------=_NextPart_000_003E_01C1DAEF.6C885F00
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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=3D'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.


------=_NextPart_000_003E_01C1DAEF.6C885F00
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4522.1800" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>
<DIV><FONT face=3DArial size=3D2><FONT face=3D"Times New Roman" size=3D3>I =
have o big=20
problem!<BR>I have a table which has a field by date type.<BR>The date form=
at is=20
mm/dd/yyyy.<BR>When I'm doing this select:<BR>select da from a where=20
da=3D'03-31-2002';<BR>the result is=20
:<BR>03-30-2002<BR>03-30-2002<BR>03-30-2002<BR>I repet: only on=20
'03-31-2002'!<BR><BR>What's going on?<BR><BR>Thanks in advance for any=20
help.</FONT><BR></FONT></DIV></FONT></DIV></BODY></HTML>

------=_NextPart_000_003E_01C1DAEF.6C885F00--