<html> <head> <title>Constants' Group GroupOn</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <link rel="stylesheet" type="text/css" href="../../../../idl.css"> </head> <body> <div id="adc-idlref"> <a name="_top_"> </a><table class="navimain" border="0" cellpadding="3"> <tr> <td class="navimain"><a href="../module-ix.html" class="navimain">Overview</a></td> <td class="navimain"><a href="module-ix.html" class="navimain">Module</a></td> <td class="navimainnone">Use</td> <td class="navimainnone">Devguide</td> <td class="navimain"><a href="../../../../index-files/index-1.html" class="navimain">Index</a></td> </tr> </table> <table class="navisub" border="0" cellpadding="0"> <tr> <td class="navisub"><a href="#Constants" class="navisub">Constants</a></td> <td class="navisub"><a href="#ConstantDetails" class="navisub">Constants' Details</a></td> </tr> </table> <hr> <table border="0" width="100%" cellpadding="5" cellspacing="3" class="title-table" style="margin-bottom:6pt;"> <tr> <td><p class="namechain"><a href="../../../../module-ix.html" class="namechain">::</a> <a href="../../../module-ix.html" class="namechain">com</a> :: <a href="../../module-ix.html" class="namechain">sun</a> :: <a href="../module-ix.html" class="namechain">star</a> :: <a href="module-ix.html" class="namechain">report</a> :: </p> </td> </tr> <tr> <td class="title"><table class="title-table" width="99%"> <tr> <td width="25%" class="title2">unpublished </td> <td width="50%" class="title">constants group GroupOn</td> <td width="*"/></tr> </table> </td> </tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>Specifies how to group data. </dd> <dt><b/></dt> <dd/></dl> </td> </tr> </table> <hr> <a name="Constants"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Constants</td> </tr> <tr> <td class="imsum_left"><a href="#DEFAULT">DEFAULT</a></td> <td class="imsum_right">The same value in the column value or expression. </td> </tr> <tr> <td class="imsum_left"><a href="#PREFIX_CHARACTERS">PREFIX_CHARACTERS</a></td> <td class="imsum_right">The same first nth of characters in the column value or expression. </td> </tr> <tr> <td class="imsum_left"><a href="#YEAR">YEAR</a></td> <td class="imsum_right">Dates in the same calendar year. </td> </tr> <tr> <td class="imsum_left"><a href="#QUARTAL">QUARTAL</a></td> <td class="imsum_right">Dates in the same calendar quarter. </td> </tr> <tr> <td class="imsum_left"><a href="#MONTH">MONTH</a></td> <td class="imsum_right">Dates in the same month. </td> </tr> <tr> <td class="imsum_left"><a href="#WEEK">WEEK</a></td> <td class="imsum_right">Dates in the same week. </td> </tr> <tr> <td class="imsum_left"><a href="#DAY">DAY</a></td> <td class="imsum_right">Dates on the same date. </td> </tr> <tr> <td class="imsum_left"><a href="#HOUR">HOUR</a></td> <td class="imsum_right">Times in the same hour. </td> </tr> <tr> <td class="imsum_left"><a href="#MINUTE">MINUTE</a></td> <td class="imsum_right">Times in the same minute. </td> </tr> <tr> <td class="imsum_left"><a href="#INTERVAL">INTERVAL</a></td> <td class="imsum_right">Values within an interval you specify. </td> </tr> </table> <a name="ConstantDetails"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle">Constants' Details</td> </tr> <tr> <td class="imdetail"><a name="DEFAULT" class="membertitle">DEFAULT</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>DEFAULT</b> = 0;<hr> <dl> <dt><b>Description</b></dt> <dd>The same value in the column value or expression. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="PREFIX_CHARACTERS" class="membertitle">PREFIX_CHARACTERS</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>PREFIX_CHARACTERS</b> = 1;<hr> <dl> <dt><b>Description</b></dt> <dd>The same first nth of characters in the column value or expression. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="YEAR" class="membertitle">YEAR</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>YEAR</b> = 2;<hr> <dl> <dt><b>Description</b></dt> <dd>Dates in the same calendar year. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="QUARTAL" class="membertitle">QUARTAL</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>QUARTAL</b> = 3;<hr> <dl> <dt><b>Description</b></dt> <dd>Dates in the same calendar quarter. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="MONTH" class="membertitle">MONTH</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>MONTH</b> = 4;<hr> <dl> <dt><b>Description</b></dt> <dd>Dates in the same month. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="WEEK" class="membertitle">WEEK</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>WEEK</b> = 5;<hr> <dl> <dt><b>Description</b></dt> <dd>Dates in the same week. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="DAY" class="membertitle">DAY</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>DAY</b> = 6;<hr> <dl> <dt><b>Description</b></dt> <dd>Dates on the same date. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="HOUR" class="membertitle">HOUR</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>HOUR</b> = 7;<hr> <dl> <dt><b>Description</b></dt> <dd>Times in the same hour. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="MINUTE" class="membertitle">MINUTE</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>MINUTE</b> = 8;<hr> <dl> <dt><b>Description</b></dt> <dd>Times in the same minute. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="INTERVAL" class="membertitle">INTERVAL</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>INTERVAL</b> = 9;<hr> <dl> <dt><b>Description</b></dt> <dd>Values within an interval you specify. </dd> </dl> </td> </tr> </table> </td> </tr> </table> <a href="#_top_">Top of Page</a><hr size="3"><p class="copyright" align="center">Copyright © 2009 Sun Microsystems, Inc.</p> </div> <!-- id="adc-idlref" --> </body> </html>