Toad World® Forums

Data grid Filter drop-down should use explicit timestamp format strings for timestamp datatypes

clicking on a TIMESTAMP value in the data grid populates the Filter popup with a quoted timestamp value with no explicit TO_TIMESTAMP formatting, which does not work for me. Should behave the same way DATE columns do.

This column is a TIMESTAMP WITH LOCAL TIME ZONE datatype:

ACTIVITY_DTTM = ‘1/9/2009 8:30:07.298000 AM’

An explicit ACTIVITY_DTTM = TO_TIMESTAMP(’’,’’) would be very useful.

You’re talking about the “Add to filter: = current value” feature? If so, this is fixed for next beta.

Yep, that’s the one.

Thanks.