From: Jan Wieck <janwieck@yahoo.com>
To: cristi <cristi@dmhi.ct.ro>
Cc: pgsql-sql@postgresql.org
Subject: Re: Date
Date: Thu, 4 Apr 2002 11:41:22 -0500 (EST)
Message-ID: <200204041641.g34GfMH07746@saturn.janwieck.net> (raw)
In-Reply-To: <004101c1dad6$474befe0$7201a8c0@dmhi.ct.ro>
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 #
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: janwieck@yahoo.com, cristi@dmhi.ct.ro
Subject: Re: Date
In-Reply-To: <200204041641.g34GfMH07746@saturn.janwieck.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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