Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-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

pgsql-sql by date

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

pgsql-admin by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group