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

Материал из Фабиус wiki
Перейти к: навигация, поиск
м
м (Advantage Database Server 12)
 
(не показано 5 промежуточных версий этого же участника)
Строка 1: Строка 1:
 
+
[[TTOC]]()
Show Navigation Component Previous Topic Next Topic
+
TTOC()
+
 
Advantage Concepts
 
Advantage Concepts
  
Строка 7: Строка 5:
  
 
Syntax
 
Syntax
TTOC(<tTimeStamp>, <nFormat>) à cTimestamp
+
TTOC(<tTimeStamp>, <nFormat>) -> cTimestamp
  
 
Parameters
 
Parameters
Строка 19: Строка 17:
 
Remarks
 
Remarks
 
These functions are used to format a timestamp into a value suitable for concatenation with a character string.
 
These functions are used to format a timestamp into a value suitable for concatenation with a character string.
 
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.
 
  
 
See Also
 
See Also
Строка 26: Строка 22:
  
 
http://devzone.advantagedatabase.com/dz/webhelp/advantage9.1/ttoc_.htm
 
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 =
 +
[[Файл:2018-10-17 15-03-20.png]]
 +
 +
 +
http://devzone.advantagedatabase.com/dz/webhelp/Advantage12/index.html?master_ttoc.htm

Текущая версия на 15:04, 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

2018-10-17 15-03-20.png


http://devzone.advantagedatabase.com/dz/webhelp/Advantage12/index.html?master_ttoc.htm