TTOC — различия между версиями
Hisava (обсуждение | вклад) м |
Hisava (обсуждение | вклад) м (→Advantage Database Server 12) |
||
| (не показано 5 промежуточных версий этого же участника) | |||
| Строка 1: | Строка 1: | ||
| − | + | [[TTOC]]() | |
| − | + | ||
| − | TTOC() | + | |
Advantage Concepts | Advantage Concepts | ||
| Строка 7: | Строка 5: | ||
Syntax | Syntax | ||
| − | TTOC(<tTimeStamp>, <nFormat>) | + | 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. | ||
| − | |||
| − | |||
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
http://devzone.advantagedatabase.com/dz/webhelp/Advantage12/index.html?master_ttoc.htm
