Re: SQL date convert
2007-02-14 13:16:48
Try searching the ADSM-L archives for terms like "current_timestamp". Here
is one entry that might be helpful:
http://adsm.org/lists/html/ADSM-L/2005-01/msg00511.html
Regards,
Andy
Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
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 02/14/2007
06:04:52 AM:
> Hi everybody,
>
> The last time when I posted a question I received a few very
> useful and quick replies. Thx for that. Hopefully this question is
> also easy for a few of you to answer.
>
> Case:
> A client want's to know how big the daily backup is for a Lotus
> client backedp up via TDP.
> I can embed a "query actlog begind=-1 node=[nodename] msg=4991 "
> in a script but the output is useless (even with grep) because TDP
> reports a summary for every *.nfs its backing up and I am only
> interested in the total bytes transferred. (which is also reported
> with msg 4991 at the end of the log).
> The alternative (which has my preference ) is an sql query:
> select START_TIME,ACTIVITY,ENTITY from summary where
> ENTITY='[nodename]' and ACTIVITY='BACKUP'
> but I struggle with the date.
> The format TSM is using in its table is
> 2007-01-15 21:08:34.000000
> I am only interested in the backupsize of last night so I use "
> START_TIME='2007-02-14%' but that is obviously not the correct syntax.
> Does anyone of you know how I must convert the date ? Or is there
> a possibility to use something like "today-1" like you use with a q
actlog.
>
> Your advise would be highly appreciated.
> Thx in advance,
> Abulifia
>
>
> ---------------------------------
> New Yahoo! Mail is the ultimate force in competitive emailing. Find
> out more at the Yahoo! Mail Championships. Plus: play games and win
prizes.
|
|
|