Re: Date - Mailing list pgsql-novice

From Jason Friedman
Subject Re: Date
Date
Msg-id Pine.LNX.4.33.0204031343420.28247-100000@abigail.powerpull.net
Whole thread Raw
In response to Date  ("cristi69" <cristiv69@yahoo.com>)
List pgsql-novice
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.
>
>


pgsql-novice by date:

Previous
From: Harald Lux
Date:
Subject: Re: Formatted printing output
Next
From: Ivan Horvath
Date:
Subject: Re: Transactions in Postgres