<!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"/> <meta http-equiv="X-UA-Compatible" content="IE=9"/> <meta name="generator" content="Doxygen 1.8.12"/> <meta name="viewport" content="width=device-width, initial-scale=1"/> <title>FreeTDS API: Datetime functions</title> <link href="tabs.css" rel="stylesheet" type="text/css"/> <script type="text/javascript" src="jquery.js"></script> <script type="text/javascript" src="dynsections.js"></script> <link href="search/search.css" rel="stylesheet" type="text/css"/> <script type="text/javascript" src="search/searchdata.js"></script> <script type="text/javascript" src="search/search.js"></script> <link href="doxygen.css" rel="stylesheet" type="text/css" /> </head> <body> <div id="top"><!-- do not remove this div, it is closed by doxygen! --> <div id="titlearea"> <table cellspacing="0" cellpadding="0"> <tbody> <tr style="height: 56px;"> <td id="projectalign" style="padding-left: 0.5em;"> <div id="projectname">FreeTDS API </div> </td> </tr> </tbody> </table> </div> <!-- end header part --> <!-- Generated by Doxygen 1.8.12 --> <script type="text/javascript"> var searchBox = new SearchBox("searchBox", "search",false,'Search'); </script> <script type="text/javascript" src="menudata.js"></script> <script type="text/javascript" src="menu.js"></script> <script type="text/javascript"> $(function() { initMenu('',true,false,'search.php','Search'); $(document).ready(function() { init_search(); }); }); </script> <div id="main-nav"></div> </div><!-- top --> <!-- window showing the filter options --> <div id="MSearchSelectWindow" onmouseover="return searchBox.OnSearchSelectShow()" onmouseout="return searchBox.OnSearchSelectHide()" onkeydown="return searchBox.OnSearchSelectKey(event)"> </div> <!-- iframe showing the search results (closed by default) --> <div id="MSearchResultsWindow"> <iframe src="javascript:void(0)" frameborder="0" name="MSearchResults" id="MSearchResults"> </iframe> </div> <div class="header"> <div class="summary"> <a href="#func-members">Functions</a> </div> <div class="headertitle"> <div class="title">Datetime functions<div class="ingroups"><a class="el" href="a00517.html">The db-lib API</a></div></div> </div> </div><!--header--> <div class="contents"> <p>Functions to manipulate <a class="el" href="a01257.html">DBDATETIME</a> structures. <a href="#details">More...</a></p> <div class="dynheader"> Collaboration diagram for Datetime functions:</div> <div class="dyncontent"> <center><table><tr><td><div class="center"><iframe scrolling="no" frameborder="0" src="a00523.svg" width="307" height="38"><p><b>This browser is not able to show SVG: try Firefox, Chrome, Safari, or Opera instead.</b></p></iframe> </div> </td></tr></table></center> </div> <table class="memberdecls"> <tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="func-members"></a> Functions</h2></td></tr> <tr class="memitem:ga129d2922d347121a6b312dd8e75ed6d2"><td class="memItemLeft" align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="a00523.html#ga129d2922d347121a6b312dd8e75ed6d2">dbdatecmp</a> (<a class="el" href="a00901.html">DBPROCESS</a> *dbproc, <a class="el" href="a01257.html">DBDATETIME</a> *d1, <a class="el" href="a01257.html">DBDATETIME</a> *d2)</td></tr> <tr class="memdesc:ga129d2922d347121a6b312dd8e75ed6d2"><td class="mdescLeft"> </td><td class="mdescRight">Compare <a class="el" href="a01257.html">DBDATETIME</a> values, similar to strcmp(3). <a href="#ga129d2922d347121a6b312dd8e75ed6d2">More...</a><br /></td></tr> <tr class="separator:ga129d2922d347121a6b312dd8e75ed6d2"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:ga38ecd55ae5827bfa0fd12e2baf0950dd"><td class="memItemLeft" align="right" valign="top">const char * </td><td class="memItemRight" valign="bottom"><a class="el" href="a00523.html#ga38ecd55ae5827bfa0fd12e2baf0950dd">dbmonthname</a> (<a class="el" href="a00901.html">DBPROCESS</a> *dbproc, char *language, int monthnum, DBBOOL shortform)</td></tr> <tr class="memdesc:ga38ecd55ae5827bfa0fd12e2baf0950dd"><td class="mdescLeft"> </td><td class="mdescRight">Get name of a month, in some human language. <a href="#ga38ecd55ae5827bfa0fd12e2baf0950dd">More...</a><br /></td></tr> <tr class="separator:ga38ecd55ae5827bfa0fd12e2baf0950dd"><td class="memSeparator" colspan="2"> </td></tr> </table> <a name="details" id="details"></a><h2 class="groupheader">Detailed Description</h2> <p>Functions to manipulate <a class="el" href="a01257.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> <h2 class="groupheader">Function Documentation</h2> <a id="ga129d2922d347121a6b312dd8e75ed6d2"></a> <h2 class="memtitle"><span class="permalink"><a href="#ga129d2922d347121a6b312dd8e75ed6d2">§ </a></span>dbdatecmp()</h2> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">int dbdatecmp </td> <td>(</td> <td class="paramtype"><a class="el" href="a00901.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="a01257.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="a01257.html">DBDATETIME</a> * </td> <td class="paramname"><em>d2</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </div><div class="memdoc"> <p>Compare <a class="el" href="a01257.html">DBDATETIME</a> values, similar to strcmp(3). </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">dbproc</td><td>contains all information needed by db-lib to manage communications with the server. </td></tr> <tr><td class="paramname">d1</td><td>a <code><a class="el" href="a01257.html">DBDATETIME</a></code> structure address </td></tr> <tr><td class="paramname">d2</td><td>another <code><a class="el" href="a01257.html">DBDATETIME</a></code> structure address </td></tr> </table> </dd> </dl> <dl class="retval"><dt>Return values</dt><dd> <table class="retval"> <tr><td class="paramname">0</td><td>d1 = d2. </td></tr> <tr><td class="paramname">-1</td><td>d1 < d2. </td></tr> <tr><td class="paramname">1</td><td>d1 > d2. </td></tr> </table> </dd> </dl> <dl class="section see"><dt>See also</dt><dd>dbdate4cmp(), <a class="el" href="a00522.html#gadddacad5c3028aa8d3726246c3825651" title="Compare two DBMONEY values. ">dbmnycmp()</a>, <a class="el" href="a00522.html#ga109d4868baccb08fad3b26b6f031dc78" title="Compare two DBMONEY4 values. ">dbmny4cmp()</a>. </dd></dl> <div class="dynheader"> Here is the call graph for this function:</div> <div class="dyncontent"> <div class="center"><iframe scrolling="no" frameborder="0" src="a00523_ga129d2922d347121a6b312dd8e75ed6d2_cgraph.svg" width="252" height="38"><p><b>This browser is not able to show SVG: try Firefox, Chrome, Safari, or Opera instead.</b></p></iframe> </div> </div> </div> </div> <a id="ga38ecd55ae5827bfa0fd12e2baf0950dd"></a> <h2 class="memtitle"><span class="permalink"><a href="#ga38ecd55ae5827bfa0fd12e2baf0950dd">§ </a></span>dbmonthname()</h2> <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="a00901.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> </tr> <tr> <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 class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">dbproc</td><td>contains all information needed by db-lib to manage communications with the server. </td></tr> <tr><td class="paramname">language</td><td><em>ignored</em>. </td></tr> <tr><td class="paramname">monthnum</td><td>number of the month, starting with 1. </td></tr> <tr><td class="paramname">shortform</td><td>set to <code>TRUE</code> for a three letter output ("Jan" - "Dec"), else zero. </td></tr> </table> </dd> </dl> <dl class="section return"><dt>Returns</dt><dd>address of null-terminated ASCII string, or <code>NULL</code> on error. </dd></dl> <dl class="section see"><dt>See also</dt><dd>db12hour(), dbdateorder(), dbdayname(), <a class="el" href="a00518.html#gadada0e76c811a6fb84ce6759bcf116b5" title="Set the language the server should use for messages. ">DBSETLNATLANG()</a>, <a class="el" href="a00518.html#ga9d660d278f3f58871b4086c0e175f4c6" title="Set db-lib or server option. ">dbsetopt()</a>. </dd></dl> <div class="dynheader"> Here is the call graph for this function:</div> <div class="dyncontent"> <div class="center"><iframe scrolling="no" frameborder="0" src="a00523_ga38ecd55ae5827bfa0fd12e2baf0950dd_cgraph.svg" width="272" height="38"><p><b>This browser is not able to show SVG: try Firefox, Chrome, Safari, or Opera instead.</b></p></iframe> </div> </div> </div> </div> </div><!-- contents --> <!-- start footer part --> <hr class="footer"/><address class="footer"><small> Generated by  <a href="http://www.doxygen.org/index.html"> <img class="footer" src="doxygen.png" alt="doxygen"/> </a> 1.8.12 </small></address> </body> </html>