Is there a way to display the date and timestamp fields with different formats when connected to a Teradata db? There is a table with one Date column and one TimeStamp column, and if the format from Toad Option | Grid is applied, it applies to both column types. is there a way to display a different format for the date column, and the time stamp column as currently Toad formats both column to look the same?
Tried going to Tools | Options | Grid. In the DateTime tab check the Custom and add the new format. But this didn't work either.
Type Name Format Format String
DATE DateTime M/d/yyyy
TIMESTAMP DateTime yyyy-MM-dd HH:mm:ss
and
Type Name Format Format String
Teradata:DATE DateTime M/d/yyyy
Teradata:TIMESTAMP DateTime yyyy-MM-dd HH:mm:ss
and
Type Name Format Format String
Odbc:DATE DateTime M/d/yyyy
Odbc:TIMESTAMP DateTime yyyy-MM-dd HH:mm:ss