📄 datefunctions.htm
字号:
<html>
<head>
<title>Date Functions</title>
</head>
<!--#include virtual="/inc/header.php"-->
<table width="100%" border="0" cellspacing="0" cellpadding="2" bgcolor="#FFFFFF">
<tr>
<td align="left">
<span style="font-family:Helvetica,Arial; font-size:12pt; color:#000000"><b>Date Functions
<br>
</b></span>
</td>
<td align="right">
<font face="Arial" size="2">
<a href="arithmeticfunctions.htm">Previous</a>
<a href="overview.htm">Top</a>
<a href="aggregatefunctions.htm">Next</a>
</font>
</td>
</tr>
</table>
<br><br>
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>
Absolute Database supports the following Date/Time functions:
<br>
<br>
<table border="0" cellpadding="1"><tr><td align="left" valign="top" width="154">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><b><u>Function</u></b>
<br>
</span></td><td align="left" valign="top" width="297">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><b><u>Description</u></b>
<br>
</span></td></tr><tr><td align="left" valign="top" width="154">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><span style="font-family:Helvetica,Arial; font-size:10pt; color:#010100">CURRENT_DATE</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>
</span></span></td><td align="left" valign="top" width="297">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Returns the current date<span style="font-family:MS Sans Serif; font-size:8pt; color:#000000">
<br>
</span></span></td></tr><tr><td align="left" valign="top" width="154">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><span style="font-family:Helvetica,Arial; font-size:10pt; color:#010100">CURRENT_TIME</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>
</span></span></td><td align="left" valign="top" width="297">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Returns the current time
<br>
</span></td></tr><tr><td align="left" valign="top" width="154">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><span style="font-family:Helvetica,Arial; font-size:10pt; color:#010100">CURRENT_TIMESTAMP</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>
</span></span></td><td align="left" valign="top" width="297">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Returns the current local date and local time as a timestamp value
<br>
</span></td></tr><tr><td align="left" valign="top" width="154">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><span style="font-family:Helvetica,Arial; font-size:10pt; color:#010100">NOW</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>
</span></span></td><td align="left" valign="top" width="297">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Returns current date and time as a timestamp value
<br>
</span></td></tr><tr><td align="left" valign="top" width="154">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><span style="font-family:Helvetica,Arial; font-size:10pt; color:#010100">SYSDATE</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>
</span></span></td><td align="left" valign="top" width="297">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Returns current date and time as a timestamp value
<br>
</span></td></tr><tr><td align="left" valign="top" width="154">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><span style="font-family:Helvetica,Arial; font-size:10pt; color:#010100">TOSTRING</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>
</span></span></td><td align="left" valign="top" width="297">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Converts date and time to string
<br>
</span></td></tr><tr><td align="left" valign="top" width="154">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><span style="font-family:Helvetica,Arial; font-size:10pt; color:#010100">TODATE</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>
</span></span></td><td align="left" valign="top" width="297">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Converts string to date and time
<br>
</span></td></tr><tr><td align="left" valign="top" width="154">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">EXTRACT
<br>
</span></td><td align="left" valign="top" width="297">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Extracts datepart component from datetime value as INTEGER
<br>
</span></td></tr></table>
<br>
<br>
<br>
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#010100"><b>CURRENT_DATE</b></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">Returns the current date.
<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">CURRENT_DATE returns 01/01/2003 (for example)
<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">
<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">
<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>CURRENT_TIME</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">Returns the current time.
<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">CURRENT_TIME returns 10:25:01 AM (for example)
<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">
<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">
<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>CURRENT_TIMESTAMP, NOW, SYSDATE</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">Returns the current local date and local time as a timestamp value.
<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">CURRENT_TIMESTAMP returns 01/01/2003 10:25:01 AM (for example)
<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">
<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">
<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>TOSTRING (datetime_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 date and/or time expression in <i>datetime_expr</i> to string 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.</span><span style="font-family:Times New Roman; font-size:12pt; color:#000000">
<br>
</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><span style="font-family:Helvetica,Arial; font-size:10pt; color:#010100">
<br>
<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). </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">DDD<span style="font-family:Helvetica,Arial; font-size:10pt; color:#010100">
<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 an abbreviation (Sun-Sat).
<br>
</span></td></tr><tr><td align="left" valign="top" width="102">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">DAY
<br>
</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 full name (Sunday-Saturday) using the strings given by the LongDayNames 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">DY
<br>
</span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Day of year (1-366).
<br>
</span></td></tr><tr><td align="left" valign="top" width="102">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">DW
<br>
</span></td><td align="left" valign="top" width="402">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Day of week (1-7).
<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>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -