Re: [SQL] copy probs

From: Cho Yan Wong <pwong(at)pobox(dot)leidenuniv(dot)nl>
To: pgsql-novice(at)postgreSQL(dot)org, pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] copy probs
Date: 1998-08-31 00:36:10
Message-ID: 3.0.5.32.19980831023610.00852120@pobox.leidenuniv.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general pgsql-sql

At 10:22 8/25/98 -0500, Jose David Martinez Cuevas wrote:
>
>
>On Tue, 25 Aug 1998, Cho Yan Wong wrote:
>
>> Everything seems to work fine except my dates are messed up. Instead of
>> 05-19-1877 I get 05-19-31284. Actually I get 31284 or 32766 for every year.
>> Help?
>
>Well, I don't know too much about Paradox.
>
>About dates, there is only one thing I can say. If you use a format like
>"yyyy-mm-dd" I'm sure your date fields won't fail. I would
>recommend you to modify your ASCII files in order to have the date's in
>such format.
>
The current format is "dd-mm-yyyy". At least, it complains when I try to
insert the values in any other way. Can anybody still help out? I'm miffed
by it completely.

Tempest

http://www.planetquake.com/infinity
http://www.wi.leidenuniv.nl/~cwong/games

In response to

  • copy probs at 1998-08-25 02:17:45 from Cho Yan Wong

Browse pgsql-admin by date

  From Date Subject
Next Message Johan.F.Strand 1998-08-31 11:48:19
Previous Message Patrick Jaromin 1998-08-30 01:16:17 Urgent..Help Needed with "Broken Pipe" on RH5/PostgreSQL Production System..

Browse pgsql-general by date

  From Date Subject
Next Message Sbragion Denis 1998-08-31 06:53:12 Re: [INTERFACES] Re: [HACKERS] changes in 6.4
Previous Message David Hartwig 1998-08-30 15:40:31 Re: [INTERFACES] Re: [HACKERS] changes in 6.4

Browse pgsql-sql by date

  From Date Subject
Next Message Johan.F.Strand 1998-08-31 11:47:57
Previous Message Herouth Maoz 1998-08-30 08:58:13 Re: [SQL] copy one to many?