Re: Date

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: Raw Message | Whole Thread | 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.
>
>

In response to

  • Date at 2002-04-03 06:13:32 from cristi69

Browse pgsql-novice by date

  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