Toad World® Forums

How to see timestamp in Db2 format?

Previously I used QMF on Mainframe to browse the DB2 database, the date fields in any of the DB2 database were displayed in DB2 date/time formate. But in Toad I see that date and time are in different format.

Can someone help on how to get the timestamp in Db2 format ?

Current Toad format : 8/24/2012 8:54:04 A
Required format or QmF format : ‘2012-08-24-08.54.04’

You can set the datetime and timestamp formats in the Options|Grid tab. You set all grids with the first date time tab or go to custom and define specific ones just for DB2. When using the custom filters, preface the format name with “DB2”.