Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting VFP date type to SQL SmallDateTime
Message
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
01038556
Message ID:
01038559
Views:
25
>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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform