ADSM-L

Re: [ADSM-L] SQL command

2008-04-04 15:51:01
Subject: Re: [ADSM-L] SQL command
From: Mario Behring <mariobehring AT YAHOO DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 4 Apr 2008 12:49:20 -0700
Andrew,

Is there an option to get this result in HH:MM format?

Thank you.

Mario




----- Original Message ----
From: Andrew Raibeck <storman AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT 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/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

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 AT VM.MARIST DOT 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

<Prev in Thread] Current Thread [Next in Thread>