Postgres Pro
Downloads
Home   >   mailing lists

Date - Mailing list pgsql-sql

From cristi
Subject Date
Date
Msg-id 004101c1dad6$474befe0$7201a8c0@dmhi.ct.ro
Whole thread Raw
Responses Re: Date  (Jan Wieck <janwieck@yahoo.com>)
List pgsql-sql
Tree view
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.

pgsql-sql by date:

Previous
From: John Proctor
Date:
Subject: 16 parameter limit
Next
From: Bernd von den Brincken
Date:
Subject: Rvsd. / Re: Named column in a Function fails at ORDER BY (PgSQL 7.1)