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/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
12:49:20:
> 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
|