|
<< Click to Display Table of Contents >> AbsDB SQL Data Conversion Functions |
  
|
AbsDB SQL Data Conversion Functions
|
<< Click to Display Table of Contents >> AbsDB SQL Data Conversion Functions |
|
Data Conversion Functions
Absolute Database provides the following functions to convert data from one data type to another:
Function |
Description |
CAST |
A general SQL function that converts a given expression to a specified data type. |
MIMETOBIN |
Converts MIME-encoded value to a binary data type. |
TODATE |
Converts string to date and time. See Date Functions topic for details. |
TOSTRING |
Converts date and time to string. See Date Functions topic for details. |
CAST (value_expr [ , | AS ] data_type)
Converts a given value_expr expression to a specified data_type.
Examples:
CAST(ytd_sales/price AS int)
CAST(memo_field AS Char(255))
MIMETOBIN (mime_expr)
Converts a given mime-encoded data from mime_expr to a binary data type.
Example:
MIMETOBIN('<mime-encoded data>')
_____________________________
27-10-2017 - Niels Knabe