-
Importing a Time Field
I am attempting to import a text file into a Sql Server table. The file contains a time field. The column in the table that I am trying to import into is a Smalldatetime field. The data looks like this "10:30". I keep getting errors on the import of the time field. Any suggestions?
-
Importing a Time Field (reply)
------------
PD at 11/15/00 11:54:21 AM
BOL says smalldate time requires 4 bytes of storage per value -maybe this is the reason.
Its stored as time. ie)10:00
------------
PD at 11/15/00 11:49:56 AM
How is the data in your text file stored?Is it only time or it also has date with it?
------------
Kevin at 11/15/00 9:35:05 AM
I am attempting to import a text file into a Sql Server table. The file contains a time field. The column in the table that I am trying to import into is a Smalldatetime field. The data looks like this "10:30". I keep getting errors on the import of the time field. Any suggestions?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|