Connected to a Netezza database. When trying to update a timestamp column in the data grid in Object Explorer, the following error occurs:
"Error posting changes" message with text, "ERROR: Bad timestamp external representation '{ts '2010-12-13 00:00:00'}' Do you want to keep your changes so you can edit them?"
This error results whether using the calendar tool or trying to directly enter the value in the text box.
WORKAROUND
Make changes by running sql in editor
STATUS
Waiting for fix in a future release of Toad for Data Analysts
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center