Delphi Database, Delphi Components from ComponentAce
Products Download Order Contact us
Data Conversion Functions
Previous  Top  Next



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. 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.

Example:
MIMETOBIN('<mime-encoded data>')  
 


        © 2003 - 2017 ComponentAce  | .net zip component | barcode for .net | delphi zip component | delphi database Dec 18, 2017