SQL Server Performance

Migration from Oracle to MSSQL

Discussion in 'SQL Server 2008 General Developer Questions' started by carrascojg72, Nov 4, 2011.

  1. carrascojg72 New Member

    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!;)
  2. Luis Martin Moderator

  3. satya Moderator

Share This Page