I am unable to delete data from timestamp(6) column from schema browser.
For example, when I have date or varchar, etc column, then to edit the column, I just double click it and then I can modify it. To delete it, I just click onto the column once and press backspace. And commit it.
But with timestamp column, this does not work.
If I try to delete data from certain row's column, then I click onto it once and press backspace. You'll notice that date still stays present there and cursor goes into first position.
Now if I delete manually this date there, and click onto another row or commit, then I get:
ORA-01847: day of month must be between 1 and last day of month
Here's an example, what I do:
Actually the timestamp is not gone here. What here happens basically is described on issue 2 also. The backspace actually does nothing at all here. So the date and timestamp are both there, and if I delete the date part (from that picture it does seem like time part is deleted already), then time still is present (if I move my cursor to the right side, then I can see it, it is just hidden there) and probably that is why I get this ORA error. So what I need to do, is slowly double click the column and CTRL+A and delete.
If editing data with timestamp column via schema browser I have another problem. Which I will illustrate via picture.
I know that this behaviour has been present for quite some time, just hadn't time to report it.
E: The heading is bit misleading, as now I know how can I achieve this, since when writing this "Issue 2" part, then I discovered how it is possible.
But still, it is strange that it behaves like that, perhaps there is something to be done.