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’