| From: | Jason Friedman <jason(at)powerpull(dot)net> |
|---|---|
| To: | <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Date |
| Date: | 2002-04-03 13:46:20 |
| Message-ID: | Pine.LNX.4.33.0204031343420.28247-100000@abigail.powerpull.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ivan Horvath | 2002-04-03 14:20:07 | Re: Transactions in Postgres |
| Previous Message | Harald Lux | 2002-04-03 13:27:37 | Re: Formatted printing output |