Well, just do the subtraction with out any function, e.g., datetime1 - datetime2
and you'll get days, hours, minutes, seconds, and subseconds. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Product Development Level 3 Team Lead Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] IBM Tivoli Storage Manager support web page: http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> wrote on 2008-04-04 12:49:20: > Andrew, > > Is there an option to get this result in HH:MM format? > > Thank you. > > Mario > > > > > ----- Original Message ---- > From: Andrew Raibeck <[EMAIL PROTECTED]> > To: ADSM-L@VM.MARIST.EDU > Sent: Friday, April 4, 2008 3:19:52 PM > Subject: Re: SQL command > > Try this: > > (datetime1 - datetime2)hours > > For example: > > select lastacc_time, \ > reg_time, \ > (lastacc_time - reg_time)hours as "HOURS" \ > from nodes > > LASTACC_TIME REG_TIME HOURS > ------------------ ------------------ ---------- > 2008-04-03 2008-02-28 837 > 16:44:40.000000 19:37:20.000000 > 2008-03-28 2008-03-27 26 > 08:21:10.000000 05:24:17.000000 > > tsm: BABYLON_4> > > Regards, > > Andy > > Andy Raibeck > IBM Software Group > Tivoli Storage Manager Client Product Development > Level 3 Team Lead > Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] > Internet e-mail: [EMAIL PROTECTED] > > IBM Tivoli Storage Manager support web page: > http://www.ibm. > com/software/sysmgmt/products/support/IBMTivoliStorageManager.html > > The only dumb question is the one that goes unasked. > The command line is your friend. > "Good enough" is the enemy of excellence. > > "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> wrote on 2008-04-04 > 10:39:39: > > > Hi list, > > > > Which SQL command or function returns the difference, in hours, from > > two date-time fields when issued against the TSM database? > > > > I need to issue this command or function inside a SELECT statement. > > I´ve tried some functions from DB2 and SQL Server (like datediff) > > but it does not work at the dsmadmc command line. > > > > Any help is appreciated. > > > > Mario > > > > > > > > > ____________________________________________________________________________________ > > You rock. That's why Blockbuster's offering you one month of > > Blockbuster Total Access, No Cost. > > http://tc.deals.yahoo.com/tc/blockbuster/text5.com > > > > > ____________________________________________________________________________________ > You rock. That's why Blockbuster's offering you one month of > Blockbuster Total Access, No Cost. > http://tc.deals.yahoo.com/tc/blockbuster/text5.com
