The following statement executes the ResCPUByAMP macro, producing a report for the period beginning 8:00 a.m. on December 25, 2006 and ending 12:00 midnight, on December 31, 2006. It includes data for nodes 123-02 through 125-04.
EXECUTE ResCPUByAmp('2006-12-25','2006-12-31', 080000, 240000, '123-02','125-04');
|ResCPUByAMP||Name of the resource usage macro|
|'2006-12-25'||Starting date of December 25, 2006|
|'2006-12-31'||Ending date of December 31, 2006|
|080000||Starting time of 8:00 a.m.|
|240000||Ending time of 12:00 midnight|
|'123-02'||Starting node of a range of nodes|
|'125-04'||Ending node of a range of nodes|
For information on using numeric values for dates, see SQL Data Types and Literals.