Re: Date - Mailing list pgsql-sql

From Jan Wieck
Subject Re: Date
Date
Msg-id 200204041641.g34GfMH07746@saturn.janwieck.net
Whole thread Raw
In response to Date  ("cristi" <cristi@dmhi.ct.ro>)
List pgsql-sql
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 #




pgsql-sql by date:

Previous
From: Kovacs Zoltan
Date:
Subject: md5 auth
Next
From: Tom Lane
Date:
Subject: Re: Rvsd. / Re: Named column in a Function fails at ORDER BY (PgSQL 7.1)