Thread: Date

Date

From
"cristi69"
Date:
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.

Re: Date

From
Jason Friedman
Date:
So that I can have more information, please do:

SELECT * FROM table LIMIT 50;

Please put on extended display (\x) if your table is wider than the
screen.

Also, do a \d table

Thanks,
Jason

On Wed, 3 Apr 2002, cristi69 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.
>
>