Friends, I need to make a migration from oracle tables to mssql tables. I've a DATE oracle data type with the next format "yyyy-mm-dd hh:mm:ss PM". What kind of data type can i use to adjust better to DATE oracle data type ? I don't want to use CAST to make a query against both database. I mean, i need to build a sql sentences to execute against both databases with a 'CAST'. I wait for you answeers, Thanks!
See SQL Server books online too for more information on SQL Server features: http://msdn.microsoft.com/en-us/library/ms166018.aspx and alos http://www.microsoft.com/sqlserver/en/us/product-info/migration.aspx for more information.