Re: [SQL] copy probs

From: Jose David Martinez Cuevas <david(at)morgana(dot)estadistica(dot)unam(dot)mx>
To: Cho Yan Wong <pwong(at)pobox(dot)leidenuniv(dot)nl>
Cc: pgsql-novice(at)postgreSQL(dot)org, pgsql-sql(at)postgreSQL(dot)org, pgsql-admin(at)postgreSQL(dot)org
Subject: Re: [SQL] copy probs
Date: 1998-08-25 15:22:14
Message-ID: Pine.LNX.3.96.980825101701.4617A-100000@morgana.estadistica.unam.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general pgsql-sql

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.

Buena Suerte Amigo !!

_______________________________________
David Martinez Cuevas
Direccion General de Estadistica, UNAM - Mexico
Tel. 622-60-80
E-mail david(at)estadistica(dot)unam(dot)mx
----------------------------------------

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 Ivan Richwalski 1998-08-25 21:38:22 Solaris 2.6 and large tables
Previous Message Cho Yan Wong 1998-08-25 02:17:45 copy probs

Browse pgsql-general by date

  From Date Subject
Next Message Gilles Darold 1998-08-25 15:31:54 JDBC with POSTGRES
Previous Message Thomas Good 1998-08-25 12:13:34 Re: [GENERAL] DBD::Pg (Errata...)

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Schmidt 1998-08-25 15:45:24 Query otimizing possible?
Previous Message Maarten Boekhold 1998-08-25 07:40:58 Re: [SQL] this one's simpler