Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Converting VFP date type to SQL SmallDateTime
Message
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
01038556
Message ID:
01038559
Vues:
22
>I am uploading data from VFP tables to SQL Server. I get error
>
>
>The conversion of char data type to smalldatetime data type
>resulted in and out-of-range smalldatetime value.
>
>
>I use value DTOC(MYDATEFLD) when inserting values to the SQL Server table.
>
>Do I get the error because some of the values in VFP table are empty?
>

It means that date is out of the allowed range: from January 1, 1753 through December 31, 9999.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform