<!-- This comment will put IE 6, 7 and 8 in quirks mode --> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/> <title>FreeTDS API: Datetime functions</title> <link href="tabs.css" rel="stylesheet" type="text/css"/> <link href="search/search.css" rel="stylesheet" type="text/css"/> <script type="text/javaScript" src="search/search.js"></script> <link href="doxygen.css" rel="stylesheet" type="text/css"/> </head> <body onload='searchBox.OnSelectItem(0);'> <!-- Generated by Doxygen 1.6.3 --> <script type="text/javascript"><!-- var searchBox = new SearchBox("searchBox", "search",false,'Search'); --></script> <div class="navigation" id="top"> <div class="tabs"> <ul> <li><a href="index.html"><span>Main Page</span></a></li> <li><a href="pages.html"><span>Related Pages</span></a></li> <li><a href="modules.html"><span>Modules</span></a></li> <li><a href="annotated.html"><span>Classes</span></a></li> <li><a href="files.html"><span>Files</span></a></li> <li> <div id="MSearchBox" class="MSearchBoxInactive"> <img id="MSearchSelect" src="search/search.png" onmouseover="return searchBox.OnSearchSelectShow()" onmouseout="return searchBox.OnSearchSelectHide()" alt=""/> <input type="text" id="MSearchField" value="Search" accesskey="S" onfocus="searchBox.OnSearchFieldFocus(true)" onblur="searchBox.OnSearchFieldFocus(false)" onkeyup="searchBox.OnSearchFieldChange(event)"/> <a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a> </div> </li> </ul> </div> </div> <div class="contents"> <h1>Datetime functions<br/> <small> [<a class="el" href="a00285.html">The db-lib API</a>]</small> </h1> <p>Functions to manipulate <a class="el" href="a00055.html">DBDATETIME</a> structures. <a href="#_details">More...</a></p> <table border="0" cellpadding="0" cellspacing="0"> <tr><td colspan="2"><h2>Functions</h2></td></tr> <tr><td class="memItemLeft" align="right" valign="top">RETCODE </td><td class="memItemRight" valign="bottom"><a class="el" href="a00291.html#ga4f3409b8c7afead50c8e6f476fa9fee3">dbdatecmp</a> (<a class="el" href="a00098.html">DBPROCESS</a> *dbproc, <a class="el" href="a00055.html">DBDATETIME</a> *d1, <a class="el" href="a00055.html">DBDATETIME</a> *d2)</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Compare <a class="el" href="a00055.html">DBDATETIME</a> values, similar to strcmp(3). <a href="#ga4f3409b8c7afead50c8e6f476fa9fee3"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">const char * </td><td class="memItemRight" valign="bottom"><a class="el" href="a00291.html#ga38ecd55ae5827bfa0fd12e2baf0950dd">dbmonthname</a> (<a class="el" href="a00098.html">DBPROCESS</a> *dbproc, char *language, int monthnum, DBBOOL shortform)</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Get name of a month, in some human language. <a href="#ga38ecd55ae5827bfa0fd12e2baf0950dd"></a><br/></td></tr> </table> <hr/><a name="_details"></a><h2>Detailed Description</h2> <p>Functions to manipulate <a class="el" href="a00055.html">DBDATETIME</a> structures. </p> <p>Defined by Sybase only. These are not implemented:</p> <ul> <li>dbdate4cmp()</li> <li>dbdate4zero()</li> <li>dbdatechar()</li> <li>dbdatename()</li> <li>dbdateorder()</li> <li>dbdatepart()</li> <li>dbdatezero()</li> <li>dbdayname() </li> </ul> <hr/><h2>Function Documentation</h2> <a class="anchor" id="ga4f3409b8c7afead50c8e6f476fa9fee3"></a><!-- doxytag: member="dblib.c::dbdatecmp" ref="ga4f3409b8c7afead50c8e6f476fa9fee3" args="(DBPROCESS *dbproc, DBDATETIME *d1, DBDATETIME *d2)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">RETCODE dbdatecmp </td> <td>(</td> <td class="paramtype"><a class="el" href="a00098.html">DBPROCESS</a> * </td> <td class="paramname"> <em>dbproc</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype"><a class="el" href="a00055.html">DBDATETIME</a> * </td> <td class="paramname"> <em>d1</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype"><a class="el" href="a00055.html">DBDATETIME</a> * </td> <td class="paramname"> <em>d2</em></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td></td> </tr> </table> </div> <div class="memdoc"> <p>Compare <a class="el" href="a00055.html">DBDATETIME</a> values, similar to strcmp(3). </p> <dl><dt><b>Parameters:</b></dt><dd> <table border="0" cellspacing="2" cellpadding="0"> <tr><td valign="top"></td><td valign="top"><em>dbproc</em> </td><td>contains all information needed by db-lib to manage communications with the server. </td></tr> <tr><td valign="top"></td><td valign="top"><em>d1</em> </td><td>a <code><a class="el" href="a00055.html">DBDATETIME</a></code> structure address </td></tr> <tr><td valign="top"></td><td valign="top"><em>d2</em> </td><td>another <code><a class="el" href="a00055.html">DBDATETIME</a></code> structure address </td></tr> </table> </dd> </dl> <dl><dt><b>Return values:</b></dt><dd> <table border="0" cellspacing="2" cellpadding="0"> <tr><td valign="top"></td><td valign="top"><em>0</em> </td><td>d1 = d2. </td></tr> <tr><td valign="top"></td><td valign="top"><em>-1</em> </td><td>d1 < d2. </td></tr> <tr><td valign="top"></td><td valign="top"><em>1</em> </td><td>d1 > d2. </td></tr> </table> </dd> </dl> <dl class="see"><dt><b>See also:</b></dt><dd>dbdate4cmp(), <a class="el" href="a00290.html#gadddacad5c3028aa8d3726246c3825651" title="Compare two DBMONEY values.">dbmnycmp()</a>, <a class="el" href="a00290.html#ga109d4868baccb08fad3b26b6f031dc78" title="Compare two DBMONEY4 values.">dbmny4cmp()</a>. </dd></dl> </div> </div> <a class="anchor" id="ga38ecd55ae5827bfa0fd12e2baf0950dd"></a><!-- doxytag: member="dblib.c::dbmonthname" ref="ga38ecd55ae5827bfa0fd12e2baf0950dd" args="(DBPROCESS *dbproc, char *language, int monthnum, DBBOOL shortform)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">const char* dbmonthname </td> <td>(</td> <td class="paramtype"><a class="el" href="a00098.html">DBPROCESS</a> * </td> <td class="paramname"> <em>dbproc</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">char * </td> <td class="paramname"> <em>language</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int </td> <td class="paramname"> <em>monthnum</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">DBBOOL </td> <td class="paramname"> <em>shortform</em></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td></td> </tr> </table> </div> <div class="memdoc"> <p>Get name of a month, in some human language. </p> <dl><dt><b>Parameters:</b></dt><dd> <table border="0" cellspacing="2" cellpadding="0"> <tr><td valign="top"></td><td valign="top"><em>dbproc</em> </td><td>contains all information needed by db-lib to manage communications with the server. </td></tr> <tr><td valign="top"></td><td valign="top"><em>language</em> </td><td><em>ignored</em>. </td></tr> <tr><td valign="top"></td><td valign="top"><em>monthnum</em> </td><td>number of the month, starting with 1. </td></tr> <tr><td valign="top"></td><td valign="top"><em>shortform</em> </td><td>set to <code>TRUE</code> for a three letter output ("Jan" - "Dec"), else zero. </td></tr> </table> </dd> </dl> <dl class="return"><dt><b>Returns:</b></dt><dd>address of null-terminated ASCII string, or <code>NULL</code> on error. </dd></dl> <dl class="see"><dt><b>See also:</b></dt><dd>db12hour(), dbdateorder(), dbdayname(), <a class="el" href="a00286.html#gadada0e76c811a6fb84ce6759bcf116b5" title="Set the language the server should use for messages.">DBSETLNATLANG()</a>, <a class="el" href="a00286.html#ga9d660d278f3f58871b4086c0e175f4c6" title="Set db-lib or server option.">dbsetopt()</a>. </dd></dl> </div> </div> </div> <!--- window showing the filter options --> <div id="MSearchSelectWindow" onmouseover="return searchBox.OnSearchSelectShow()" onmouseout="return searchBox.OnSearchSelectHide()" onkeydown="return searchBox.OnSearchSelectKey(event)"> <a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark"> </span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark"> </span>Classes</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark"> </span>Files</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark"> </span>Functions</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark"> </span>Variables</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(5)"><span class="SelectionMark"> </span>Typedefs</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(6)"><span class="SelectionMark"> </span>Enumerations</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(7)"><span class="SelectionMark"> </span>Enumerator</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(8)"><span class="SelectionMark"> </span>Defines</a></div> <!-- iframe showing the search results (closed by default) --> <div id="MSearchResultsWindow"> <iframe src="" frameborder="0" name="MSearchResults" id="MSearchResults"> </iframe> </div> <hr class="footer"/><address style="text-align: right;"><small>Generated on Wed Aug 17 22:22:31 2011 for FreeTDS API by <a href="http://www.doxygen.org/index.html"> <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.6.3 </small></address> </body> </html>