📄 dataconversionfunctions.htm

📁 Absolute Database 5.12 src. Absolute Database lets you forget the Borland Database Engine (BDE). Th
💻 HTM
字号:
<html>
<head>
   <title>Data Conversion 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>Data Conversion Functions
<br>
</b></span>
    </td>
    <td align="right">
     <font face="Arial" size="2">
     <a href="aggregatefunctions.htm">Previous</a>&nbsp;
     <a href="overview.htm">Top</a>&nbsp;
     <a href="systemfunctions.htm">Next</a>
     </font>
    </td>
  </tr>
</table>
<br><br>



<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>
Absolute Database provides the following functions to convert data from one data type to another:
<br>

<br>
<table border="0" cellpadding="1"><tr><td align="left" valign="top" width="84">
<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="262">
<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="84">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">CAST
<br>
</span></td><td align="left" valign="top" width="262">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">A general SQL function that converts a given expression to a specified data type.
<br>
</span></td></tr><tr><td align="left" valign="top" width="84">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">MIMETOBIN
<br>
</span></td><td align="left" valign="top" width="262">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Converts MIME-encoded value to a binary data type.
<br>
</span></td></tr><tr><td align="left" valign="top" width="84">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">TODATE
<br>
</span></td><td align="left" valign="top" width="262">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Converts string to date and time. See <a href=datefunctions.htm>Date Functions</a> topic for details.
<br>
</span></td></tr><tr><td align="left" valign="top" width="84">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">TOSTRING
<br>
</span></td><td align="left" valign="top" width="262">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Converts date and time to string. See <a href=datefunctions.htm>Date Functions</a> topic for details.
<br>
</span></td></tr></table>
<br>

<br>

<br>
<b>CAST (value_expr [ , | AS ] data_type) </b>
<br>
<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 a given <i>value_expr</i> expression to a specified <i>data_type</i>.
<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>Examples:</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">CAST(ytd_sales/price&nbsp;<b>AS</b>&nbsp;int)
&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">CAST(memo_field&nbsp;AS&nbsp;Char(255))
&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">
<br>

<br>
<b>MIMETOBIN (mime_expr) </b>
<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 a given mime-encoded data from <i>mime_expr</i> to a binary data type. See also 'Export SQL' tab in DBManager utility supplied with the Absolute DB to get an example of MIME encoded binary data in a SQL command.
<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">MIMETOBIN('&lt;mime-encoded&nbsp;data&gt;')
&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">
<br>

<br>
</span></span>

<!--#include virtual="/inc/footer.php"--> 
</html>
⌨️ 快捷键说明

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