One running a query for a Timestamp field in the new DB2 V8 Command center, we get the result as Oct 10, 2005 10:46:06 AM 000000.
I could not find any setting in the tool, which would allow me to configure the timestamp output in the format yyyy-mm-dd-hh:mm:ss:ssssss. Can anyone help to see if the tool can be configured to give results in the desired format.
I believe that what you are seeing is the java representation of a timestamp. The command center sees that the column is a timestamp and uses java.sql.Timestamp for the object Class for that column. If you want something else, just change your query to format it using a function.