datefunctions.htm

Absolute Database 5.12 src. Absolute Database lets you forget the Borland Database Engine (BDE). Th

</span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Displays the year as a two-digit number (00-99).
<br>
</span></td></tr><tr><td align="left" valign="top" width="102">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">YYYY, YEAR
<br>
</span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Displays the year as a four-digit number (0000-9999).
<br>
</span></td></tr><tr><td align="left" valign="top" width="102">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">H, H12
<br>
</span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Hour of day without a leading zero (1-12).
<br>
</span></td></tr><tr><td align="left" valign="top" width="102">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">H24
<br>
</span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Hour of day without a leading zero (1-24).
<br>
</span></td></tr><tr><td align="left" valign="top" width="102">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">HH, HH12
<br>
</span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Hour of day with a leading zero (01-12).
<br>
</span></td></tr><tr><td align="left" valign="top" width="102">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">HH24
<br>
</span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Hour of day with a leading zero (01-24).
<br>
</span></td></tr><tr><td align="left" valign="top" width="102">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">N
<br>
</span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Displays the minute without a leading zero (0-59).
<br>
</span></td></tr><tr><td align="left" valign="top" width="102">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">NN
<br>
</span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Displays the minute with a leading zero (00-59).
<br>
</span></td></tr><tr><td align="left" valign="top" width="102">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">S
<br>
</span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Displays the second without a leading zero (0-59).
<br>
</span></td></tr><tr><td align="left" valign="top" width="102">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">SS
<br>
</span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Displays the second with a leading zero (00-59).
<br>
</span></td></tr><tr><td align="left" valign="top" width="102">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">AMPM
<br>
</span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Uses the 12-hour clock for the preceding h or hh specifier, and displays 'AM' for any hour before noon, and 'PM' for any hour after noon.
<br>
</span></td></tr><tr><td align="left" valign="top" width="102">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">'Text', "Text"&nbsp;&nbsp;&nbsp;
<br>
</span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Characters enclosed in single or double quotes are displayed as-is, and do not affect formatting.
<br>
</span></td></tr><tr><td align="left" valign="top" width="102">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">:
<br>
</span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Displays the time separator character ':'.
<br>
</span></td></tr><tr><td align="left" valign="top" width="102">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">/
<br>
</span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Displays the date separator character '/'.
<br>
</span></td></tr><tr><td align="left" valign="top" width="102">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">,
<br>
</span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Displays the character ','.
<br>
</span></td></tr><tr><td align="left" valign="top" width="102">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">.
<br>
</span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Displays the character '.'.
<br>
</span></td></tr><tr><td align="left" valign="top" width="102">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">;
<br>
</span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Displays the character ';'.
<br>
</span></td></tr><tr><td align="left" valign="top" width="102">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">-
<br>
</span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Displays the character '-'.
<br>
</span></td></tr></table>
<br>
</span><span style="font-family:Helvetica,Arial; font-size:4pt; color:#000000">
<br>

<br>
</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><b>Example:</b>
<br>
<table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"></span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">TODATE('01/01/2003','mm/dd/yyyy')&nbsp;returns&nbsp;01/01/2003
&nbsp;<br>
</span></td></tr></table><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Courier New; font-size:8pt; color:#000000">
&nbsp;<br>
</span></td></tr></table><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Courier New; font-size:8pt; color:#000000">
&nbsp;<br>
</span></td></tr></table><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Courier New; font-size:8pt; color:#000000">
&nbsp;<br>
</span></td></tr></table><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Courier New; font-size:8pt; color:#000000"></span></td></tr></table><span style="font-family:Courier New; font-size:8pt; color:#000000"></span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><span style="font-family:Helvetica,Arial; font-size:10pt; color:#010100"><b>EXTRACT (date_part FROM datetime_expression)</b></span></span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>
</span><span style="font-family:Helvetica,Arial; font-size:4pt; color:#000000">
<br>
</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Extracts datepart component from datetime value as INTEGER.
<br>

<br>
<i>date_part </i>could be one of the following expressions:
<br>
<table border="0" cellpadding="1"><tr><td align="left" valign="top" width="131">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><b>date_part</b>
<br>
</span></td><td align="left" valign="top" width="149">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><b>Range</b>
<br>
</span></td></tr><tr><td align="left" valign="top" width="131">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">YEAR
<br>
</span></td><td align="left" valign="top" width="149">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">1 to 9999
<br>
</span></td></tr><tr><td align="left" valign="top" width="131">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">MONTH
<br>
</span></td><td align="left" valign="top" width="149">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">1 to 12
<br>
</span></td></tr><tr><td align="left" valign="top" width="131">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">DAY
<br>
</span></td><td align="left" valign="top" width="149">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">1 to 31
<br>
</span></td></tr><tr><td align="left" valign="top" width="131">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">HOUR
<br>
</span></td><td align="left" valign="top" width="149">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">0 to 23
<br>
</span></td></tr><tr><td align="left" valign="top" width="131">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">MINUTE
<br>
</span></td><td align="left" valign="top" width="149">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">0 to 59
<br>
</span></td></tr><tr><td align="left" valign="top" width="131">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">SECOND
<br>
</span></td><td align="left" valign="top" width="149">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">0 to 59
<br>
</span></td></tr></table>
<br>

<br>
</span><span style="font-family:Helvetica,Arial; font-size:4pt; color:#000000">
<br>
</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><b>Example:</b>
<br>
<table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"></span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">EXTRACT&nbsp;(YEAR&nbsp;FROM&nbsp;date_field)&nbsp;returns&nbsp;2003&nbsp;(for&nbsp;example&nbsp;if&nbsp;date_field&nbsp;value&nbsp;is&nbsp;01/01/2003)
&nbsp;<br>
</span></td></tr></table><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Courier New; font-size:8pt; color:#000000">
&nbsp;<br>
</span></td></tr></table><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Courier New; font-size:8pt; color:#000000">
&nbsp;<br>
</span></td></tr></table><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Courier New; font-size:8pt; color:#000000">
&nbsp;<br>
</span></td></tr></table><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Courier New; font-size:8pt; color:#000000"></span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
&nbsp;<br>
</span></td></tr></table><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"></span></span></td></tr></table>

<!--#include virtual="/inc/footer.php"--> 
</html>