Arun Bv wrote:hi can anyone tell me how to find time diffe in minutes from timestamp...
i tried below sql queries but this is not retrieving correct diff in minutes
As you allege to know COBOL, why not retrieve the timestamps from DB2 and then calculate the difference in the COBOL program in which the queries are embedded?
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day