ADSM-L

sql query required

2006-07-17 07:34:11
Subject: sql query required
From: "Sujay Dinakar R." <sujay_dinakar AT YAHOO DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 17 Jul 2006 04:33:16 -0700
Dear all,
   
  can any one please tell me how to find the size of the archived files in a 
particular month.
   
  by issuing the command
  select * from Archives where ARCHIVE_DATE > '2006-01-01 08:00:00' AND 
ARCHIVE_DATE < '2006-02-01 18:00:00'
   
  i could able to get the list of files and file ID but i could not able to get 
the size coloum.
   
  can any one know how to get the size of the archived files.
   
  Best Regards
  sujay dinakar r
   


Regards 
Sujay Dinakar .R

                
---------------------------------
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ 
countries) for 2¢/min or less.

<Prev in Thread] Current Thread [Next in Thread>