Invalid argument

[SPYO_O]

Hello
I have a problem when try to update rows using "select for update" statement. When I set the value '01/01/0001' in a date field then a error message appear "Invalid Argument".
but if I write the DML update table_x set date_x=to_date('01/01/0001','dd/mm/yyyy') then it works fine.

Any idea how I can fix this problem?
regards

 

[Marco Kalter]

It may be that client-side dates do not go this low. You can go to Preferences > SQL Window and enable the "Date fields to_char" option. Now date values are converted to and from a character representation on the server using the NLS_DATE_FORMAT of the session.

 

[SPYO_O]

Thank you.. it work now!!!