Re: Date

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(at)Yahoo(dot)com #