TeriCoombes
Technical User
My department is converting from MS Access to SQL Server. When I use the DTS, my time fields cause errors and will not copy over. Is there an SQL field type for time values?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Time values from Access to SQL Server
- Thread starter TeriCoombes
- Start date
- Status
mrdenny
Programmer
- May 27, 2002
- 11,595
Time values are stored within the datetime datatype. There is no seperate data type for time in SQL Server.
Denny
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
(My very old site)
Denny
--Anything is possible. All it takes is a little research. (Me)
(My very old site)
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question