SQL date convert
2007-02-14 08:05:17
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.
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- SQL date convert,
Ronald Le Large <=
|
|
|