<html> <head> <title>Constants' Group DataPilotFieldGroupBy</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">sheet</a> :: </p> </td> </tr> <tr> <td class="title">constants group DataPilotFieldGroupBy</td> </tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>These constants select different types for grouping members of a DataPilot field by date or time. </dd> <dt><b>See also</b></dt> <dd><a href="DataPilotFieldGroupInfo.html">DataPilotFieldGroupInfo</a></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="#SECONDS">SECONDS</a></td> <td class="imsum_right">Groups all members of a DataPilot field containing a date/time value by their current value for seconds. </td> </tr> <tr> <td class="imsum_left"><a href="#MINUTES">MINUTES</a></td> <td class="imsum_right">Groups all members of a DataPilot field containing a date/time value by their current value for minutes. </td> </tr> <tr> <td class="imsum_left"><a href="#HOURS">HOURS</a></td> <td class="imsum_right">Groups all members of a DataPilot field containing a date/time value by their current value for hours. </td> </tr> <tr> <td class="imsum_left"><a href="#DAYS">DAYS</a></td> <td class="imsum_right">Groups all members of a DataPilot field containing a date/time value by their calendar day, or by ranges of days. </td> </tr> <tr> <td class="imsum_left"><a href="#MONTHS">MONTHS</a></td> <td class="imsum_right">Groups all members of a DataPilot field containing a date/time value by their month. </td> </tr> <tr> <td class="imsum_left"><a href="#QUARTERS">QUARTERS</a></td> <td class="imsum_right">Groups all members of a DataPilot field containing a date/time value by their quarter. </td> </tr> <tr> <td class="imsum_left"><a href="#YEARS">YEARS</a></td> <td class="imsum_right">Groups all members of a DataPilot field containing a date/time value by their year. </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="SECONDS" class="membertitle">SECONDS</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>SECONDS</b> = 1;<hr> <dl> <dt><b>Description</b></dt> <dd>Groups all members of a DataPilot field containing a date/time value by their current value for seconds. </dd> <dd><p>Example: The group <em>:02</em> will contain all members that contain a time with a seconds value of 2, regardless of the date, hours and minutes of the member, e.g. <em>2002-Jan-03 00:00:02</em> or <em>1999-May-02 12:45:02</em>.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="MINUTES" class="membertitle">MINUTES</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>MINUTES</b> = 2;<hr> <dl> <dt><b>Description</b></dt> <dd>Groups all members of a DataPilot field containing a date/time value by their current value for minutes. </dd> <dd><p>Example: The group <em>:02</em> will contain all members that contain a time with a minutes value of 2, regardless of the date, hours and seconds of the member, e.g. <em>2002-Jan-03 00:02:00</em> or <em>1999-May-02 12:02:45</em>.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="HOURS" class="membertitle">HOURS</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>HOURS</b> = 4;<hr> <dl> <dt><b>Description</b></dt> <dd>Groups all members of a DataPilot field containing a date/time value by their current value for hours. </dd> <dd><p>Example: The group <em>02</em> will contain all members that contain a time with a hour value of 2, regardless of the date, minutes and seconds of the member, e.g. <em>2002-Jan-03 02:00:00</em> or <em>1999-May-02 02:12:45</em>.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="DAYS" class="membertitle">DAYS</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>DAYS</b> = 8;<hr> <dl> <dt><b>Description</b></dt> <dd>Groups all members of a DataPilot field containing a date/time value by their calendar day, or by ranges of days. </dd> <dd><p>Examples: <ul> <li>Calendar day grouping: The group <em>Jan 03</em> will contain all members that contain the january 3rd, regardless of the year or time of the member, e.g. <em>2002-Jan-03 00:00:00</em> or <em>1999-Jan-03 02:12:45</em>.</li> <li>Day range grouping: The group <em>2002-Jan-03 - 2002-Jan-09</em> will contain all members with a date/time in the range from 2002-Jan-03 00:00:00 through 2002-Jan-09 23:59:59.</li> </ul></p> <p>See descriptions for <a href="XDataPilotFieldGrouping.html">XDataPilotFieldGrouping</a>::<a href="XDataPilotFieldGrouping.html#createDateGroup">createDateGroup</a> for more details about day grouping.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="MONTHS" class="membertitle">MONTHS</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>MONTHS</b> = 16;<hr> <dl> <dt><b>Description</b></dt> <dd>Groups all members of a DataPilot field containing a date/time value by their month. </dd> <dd><p>Example: The group <em>Jan</em> will contain all members with a date in the month january, regardless of the year, day, or time of the member, e.g. <em>2002-Jan-03 00:00:00</em> or <em>1999-Jan-02 02:12:45</em>.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="QUARTERS" class="membertitle">QUARTERS</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>QUARTERS</b> = 32;<hr> <dl> <dt><b>Description</b></dt> <dd>Groups all members of a DataPilot field containing a date/time value by their quarter. </dd> <dd><p>Example: The group <em>Q1</em> will contain all members with a date in the first quarter of a year (i.e. the months january, february, and march), regardless of the year, day, or time of the member, e.g. <em>2002-Jan-03 00:00:00</em> or <em>1999-Mar-02 02:12:45</em>.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="YEARS" class="membertitle">YEARS</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>YEARS</b> = 64;<hr> <dl> <dt><b>Description</b></dt> <dd>Groups all members of a DataPilot field containing a date/time value by their year. </dd> <dd><p>Example: The group <em>1999</em> will contain all members with a date in the year 1999, regardless of the month, day, or time of the member, e.g. <em>1999-Jan-03 00:00:00</em> or <em>1999-May-02 02:12:45</em>.</p> </dd> </dl> </td> </tr> </table> </td> </tr> </table> <a href="#_top_">Top of Page</a><hr size="3"><p class="copyright" align="center">Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.</p> </div> <!-- id="adc-idlref" --> </body> </html>