Oracle Database - Date differences in Oracle 10g and 11g?

Asked By vinod kumar on 07-Mar-13 04:42 AM
Hi friends,

I'm creating a Test table with 2 columns INT type and DATE type. In Oracle 10g  Date field taken '23-09-2006 02:50:00' (datetime) values, but in Oracle 11g not taken same value. why? what is the difference between Date Formats in Oracle 10g and 11g?
Ex:
In Oracle 10g :

CREATE TABLE  Test(ID INT,JoinDt DATE);
INSERT INTO Test VALUES (1,'23-09-2006 02:50:00');
SELECT * FROM Test;

result:
ID      JoinDt
1       23-09-2006 02:50:00   

Hi friends,

In Oracle 11g :

CREATE TABLE  Test(ID INT,JoinDt DATE);
INSERT INTO Test VALUES (1,'23-09-2006 02:50:00');
SELECT * FROM Test;

result: