• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 321
  • Last Modified:

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

0
chickanna
Asked:
chickanna
2 Solutions
 
dodge20Commented:
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
 
Alpesh PatelAssistant ConsultantCommented:
DateTime in SQL Server
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now