📄 datefunctions.htm

📁 Absolute Database 5.12 src. Absolute Database lets you forget the Borland Database Engine (BDE). Th
💻 HTM
📖 第 1 页 / 共 3 页
字号:
</span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Displays the month as a number 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">MM
<br>
</span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Displays the month as a number 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">MON
<br>
</span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Displays the month as an abbreviation (Jan-Dec) using the strings given by the ShortMonthNames global variable.
<br>
</span></td></tr><tr><td align="left" valign="top" width="102">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">MONTH
<br>
</span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Displays the month as a full name (January-December) using the strings given by the LongMonthNames global variable.
<br>
</span></td></tr><tr><td align="left" valign="top" width="102">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">RM
<br>
</span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Roman numeral month (I-XII; JAN = I).
<br>
</span></td></tr><tr><td align="left" valign="top" width="102">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">YY
<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 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">Q
<br>
</span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Quarter of year (1, 2, 3, 4; JAN-MAR = 1).
<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><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"><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">TOSTRING(NOW,'mm/dd/yyyy')&nbsp;returns&nbsp;01/01/2003&nbsp;(for&nbsp;example)
&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>TODATE (string_expr, date_format )</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">Converts string in <i>string_expr</i> to to date and/or time expression in accordance with <i>date_format</i> format string.
<br>
The following is a list of options for the <i>date_format</i> parameter. These parameters can be used in many combinations.
<br>
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#010100">
<br>
</span></span><span style="font-family:Times New Roman; font-size:12pt; color:#000000"><table border="0" cellpadding="1"><tr><td align="left" valign="top" width="102">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><span style="font-family:Helvetica,Arial; font-size:10pt; color:#010100"><b><u>Parameter</u></b></span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>
</span></span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><span style="font-family:Helvetica,Arial; font-size:10pt; color:#010100"><b><u>Description</u></b></span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>
</span></span></td></tr><tr><td align="left" valign="top" width="102">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><span style="font-family:Helvetica,Arial; font-size:10pt; color:#010100">D</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>
</span></span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><span style="font-family:Helvetica,Arial; font-size:10pt; color:#010100">Displays the day as a number without a leading zero (1-31).&nbsp;&nbsp;&nbsp;</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>
</span></span></td></tr><tr><td align="left" valign="top" width="102">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><span style="font-family:Helvetica,Arial; font-size:10pt; color:#010100">DD</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>
</span></span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Displays the day as a number with a leading zero (01-31).
<br>
</span></td></tr><tr><td align="left" valign="top" width="102">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">M
<br>
</span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Displays the month as a number 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">MM
<br>
</span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Displays the month as a number 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">YY
<br>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -