TTOC — различия между версиями

Материал из Фабиус wiki
Перейти к: навигация, поиск
м
м
Строка 25: Строка 25:
 
= Note =
 
= Note =
 
Advantage Expression Engine functions can be used in expressions such as record filter expressions and index expressions. They are not necessarily scalars supported within SQL statements. For a list of supported SQL scalar functions, see Supported Scalar Functions.
 
Advantage Expression Engine functions can be used in expressions such as record filter expressions and index expressions. They are not necessarily scalars supported within SQL statements. For a list of supported SQL scalar functions, see Supported Scalar Functions.
 +
 +
= Advantage Database Server 12 =

Версия 15:03, 17 октября 2018

TTOC() Advantage Concepts

Advantage Expression Engine function that converts a timestamp value into a character string.

Syntax TTOC(<tTimeStamp>, <nFormat>) -> cTimestamp

Parameters <tTimestamp> The timestamp value to format.

<nFormat> The format to be used for the timestamp value, [ 1 | 2 | 3 ] are the only formats currently supported.

Return Values TTOC() returns a character string representation of a timestamp value. The function returns NULL if the parameter is a null date in an ADT table. Format 1 returns a character string of yyyymmddhhmmss. Format 2 returns only the time portion as hhmmss. Format 3 returns an XML DateTime format of yyyy-mm-ddThh:mm:ss.

Remarks These functions are used to format a timestamp into a value suitable for concatenation with a character string.

See Also STOTS()

http://devzone.advantagedatabase.com/dz/webhelp/advantage9.1/ttoc_.htm

Note

Advantage Expression Engine functions can be used in expressions such as record filter expressions and index expressions. They are not necessarily scalars supported within SQL statements. For a list of supported SQL scalar functions, see Supported Scalar Functions.

Advantage Database Server 12