Hi,
I'm trying to export the dml from sql developer(v 17.4) but the date column is not coming as expected.
While inserting the record i used SYSDATE for date field but i think implicitly the sql developer is converting that SYSDATE to to_date(). Here's the Query I'm using to insert-
Insert into BRG_OWNER.INT_OBJ (INT_OBJ_ID,INT_OBJ_NM,CREATE_DT,CREATE_USER_ID**,UPDATE_DT**,UPDATE_USER_ID) values (2016,'RDS_BV_RETURN_MAIL_INFO',SYSDATE,'IntegrationUser',SYSDATE,'IntegrationUser');
But in Export i'm getting this -
Insert into BRG_OWNER.INT_OBJ (INT_OBJ_ID,INT_OBJ_NM,CREATE_DT,CREATE_USER_ID,UPDATE_DT,UPDATE_USER_ID) values (2016,'RDS_BV_RETURN_MAIL_INFO',to_date('09-AUG-23','DD-MON-RR'),'IntegrationUser',to_date('09-AUG-23','DD-MON-RR'),'IntegrationUser');
Does anyone know how can we resolve this?