Re: Select statement question
2002-08-02 04:47:23
Wayne,
> Can anyone help me with a select query that will tell me how much data I've
> backed up in the last 24 hours?
select sum(cast(bytes/1024/1024/1024 as decimal(6,3))) "Total GB Backup" -
from summary where start_time>=current_timestamp - 1 day and activity='BACKUP'
Cheers,
Henk ten Have
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Re: Select statement question,
Henk ten Have <=
|
|
|