Problem on query with date "DD/MM/YYYY" between Oracle sqlplus and dblink dg4mssql

Hello Gurus,

     My database Oracle in version 11.2.0.3 and i execute a query by a databaselink ( dg4mssql ) to an other database Sqlserver 2008.

> sqlplus  select "ID", "dte_cre" from annuaire_acteur where "dte_cre" > to_date('01/11/2014','DD/MM/YYYY');   >>>> the query is not correct. ( Annexe 1 )

> select "ID", "dte_cre" from annuaire_acteur where "dte_cre" > to_date('01/11/14','DD/MM/RR');   >>>>> the query is correct. ( Annexe 2 )

my question i would like understand and have i to change or set up parameter in Sqlplus or Parameters in dg4msql admin.

best regards

JP

Annexe 1

   

	5583 15-JUL-14
	5584 15-JUL-14
	5585 15-JUL-14
	5586 16-JUL-14
	5587 16-JUL-14