Toad World® Forums

Problem deleting the value of a DATE field in the query results grid

  1. Query data from simple table.
  2. Go to query result grid, select a value and press DELETE on keyboard, get out of the field (TAB).
  3. If it is a NUMBER or VARCHAR2 column - no problems, the record marks as edited, press commit and done.
    But if it is a DATE field then after pressing TAB, the value changes year to 1899 and nothing is deleted.
    Only option is to open the calendar and press “Clear”.

Is it a bug?

Hi Martin,

Good found, thanks to report this issus.

we have create defect ID SQLNAV-1983 for this.

Regards,

Michael