Postgres Pro
Downloads
Home   >   mailing lists

Date - Mailing list pgsql-sql

From cristi69
Subject Date
Date
Msg-id 005d01c1dad6$91165160$7201a8c0@dmhi.ct.ro
Whole thread Raw
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: Iklódi Lajos
Date:
Subject: Update in trigger
Next
From: Jean-Christophe FABRE
Date:
Subject: bytea or large object