Use the following syntax to specify the date and time (optional):
mm/dd/yy[:hh:mm:ss]
A 24-hour clock is assumed.
When you specify the date, the system procedures interpret it as follows:
If both the date and the time are specified, the dbcc operation that completed at the specified date and time is selected for the report.
If the specified date is the current date, and no time is specified, the time is automatically set to the current time. The dbcc operation that completed within the previous 24 hours with a finish time closest to the current time is selected for the report.
If the specified date is not the current date, and no time is specified, the time is automatically set to “23:59:59”. The dbcc checkstorage operation that completed with a finish date and time closest to the specified date and system-supplied time is selected for the report.
For example, suppose the most recent dbcc checkstorage operation completed on March 4, 1997 at 10:20:45.
If you specify the date as “03/04/97”, the system procedure interprets the date as 03/04/97:23:59:59. This date and time are compared to the actual finish date and time of 03/04/97:10:20:45.
If you specify the date as “03/04/97:10:00:00”, the operation that completes at 10:20:45 is not selected for the report because only the operations that complete on or before the specified time meet the criteria.
If you specify the date as “03/06/97”, no report is generated because the most recent operation completed more than 24 hours earlier.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
