sybase timestamp and sql server 2008 compatible data type

Experts, how do I migrate data from a sybase timestamp column to sql server 2008. what data type shoul d I use? I am trying to use the import and export wizard that comes with the product.

My date in sybase timestamp column looks like this ..

2003-12-01 12:33:13.953
2003-03-29 00:00:00.000

chickannaAsked:
Who is Participating?
 
Alpesh PatelConnect With a Mentor Assistant ConsultantCommented:
DateTime in SQL Server
0
 
dodge20Connect With a Mentor Commented:
Here is a list of the data types in sql server.
http://msdn.microsoft.com/en-us/library/ms187752.aspx

Looks like datetime will work for you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.