Search code examples
sqlsql-serveroraclesqldatatypes

SQL Server datetime to Oracle

If you have in SQL Server DATETIME, what will this be in Oracle?

DATE, where you loose the fractional parts of a second or better TIMESTAMP(3)?

Solution

  • If you want to preserve the fractional seconds, you'd use a TIMESTAMP(3) (or just a TIMESTAMP). If you don't care about the fractional seconds, you'd use a DATE.