Thread: 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
outputof   "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 #