Re: [ADSM-L] SQL command
2008-04-04 15:51:01
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
|
|
|