SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Equivalent datatype in Oracle for datetime of SQL Server

876448Jul 19 2011 — edited Jul 20 2011

Hello Everyone,

I'm very much new to Oracle. I have been working with SQL Server since 3yrs. Currently I'm working with Oracle 11g.

What is the equivalent datatype in oracle for datetime in sql server with which has the format YYYY-MM-DD HH:MM:SS?

I tried with timestamp and date which didnt solve my prob.... Please help me in using the equivalent datatype for the format provided above...

Regards,
Bhanu Yalamanchi.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 17 2011

Added on Jul 19 2011

9 comments

5,432 views