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>')