PRESENTATION function

Returns the string presentation of the value of arbitrary type.

The function's parameter is an expression of any type.

It returns a value of the STRING type.

The result of the function cannot be used within other functions, except for the PRESENTATION function.

Example:

SELECT
   PRESENTATION(ExpInvoice.Recipient) AS Recipient,
   PRESENTATION(ExpInvoice.Date) AS Date
FROM
   Document.ExpInvoice AS ExpInvoice

Result:

Recipient	Date
Urupinsk products	07/01/2000 12:00:00
“Giant” store	07/01/2000 12:00:00
“Giant” store	07/10/2000 12:00:00
“Giant” store	08/02/2000 12:00:00
Urupinsk products	09/03/2000 12:00:00

 

See also: Functions of Query Language