Difference between revisions of "TYPE()"
From Lianjapedia
(→Description) |
Yvonne.milne (Talk | contribs) (→See Also) |
||
(6 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to return a letter code that represents a data type | Function to return a letter code that represents a data type | ||
− | |||
==Syntax== | ==Syntax== | ||
TYPE(<expC>) | TYPE(<expC>) | ||
− | |||
==See Also== | ==See Also== | ||
− | [[ATOH()]], [[BIN2I()]], [[BIN2L()]], [[BIN2W()]], [[CAST()]], [[CTOD()]], [[CTOT()]], [[DTOC()]], [[DTOM()]], [[DTOS()]], [[DTOV()]], [[ERROR()]], [[ERRNO()]], [[ETOS()]], [[HTOA()]], [[I2BIN()]], [[ISALPHA()]], [[ISDIGIT()]], [[L2BIN()]], [[MESSAGE()]], [[MTOS()]], [[ | + | [[ATOH()]], [[BIN2I()]], [[BIN2L()]], [[BIN2W()]], [[CAST()]], [[CTOD()]], [[CTOT()]], [[DTOC()]], [[DTOM()]], [[DTOS()]], [[DTOV()]], [[ERROR()]], [[ERRNO()]], [[ETOS()]], [[HTOA()]], [[I2BIN()]], [[ISALPHA()]], [[ISDIGIT()]], [[L2BIN()]], [[MESSAGE()]], [[MTOS()]], [[SET JSONBOOLEAN]], [[STR()]], [[STRZERO()]], [[TTOC()]], [[TTOD()]], [[TYPEOF()]], [[VAL()]], [[VARTYPE()]], [[VTOD()]] |
− | + | ||
==Description== | ==Description== | ||
The TYPE() function returns a letter code which represents the data type of the expression in <expC>. The return value of the letter code is a character string from the table below. | The TYPE() function returns a letter code which represents the data type of the expression in <expC>. The return value of the letter code is a character string from the table below. | ||
− | + | {| class="wikitable" width="100%" | |
− | {| class="wikitable" | + | |
!Data type||Return Value | !Data type||Return Value | ||
|- | |- | ||
Line 89: | Line 85: | ||
|- | |- | ||
|} | |} | ||
− | |||
− | |||
− | |||
==Example== | ==Example== | ||
Line 100: | Line 93: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
− | [[Category: | + | [[Category:Formatting Functions]] |
− | + |
Latest revision as of 05:40, 22 February 2023
Contents
Purpose
Function to return a letter code that represents a data type
Syntax
TYPE(<expC>)
See Also
ATOH(), BIN2I(), BIN2L(), BIN2W(), CAST(), CTOD(), CTOT(), DTOC(), DTOM(), DTOS(), DTOV(), ERROR(), ERRNO(), ETOS(), HTOA(), I2BIN(), ISALPHA(), ISDIGIT(), L2BIN(), MESSAGE(), MTOS(), SET JSONBOOLEAN, STR(), STRZERO(), TTOC(), TTOD(), TYPEOF(), VAL(), VARTYPE(), VTOD()
Description
The TYPE() function returns a letter code which represents the data type of the expression in <expC>. The return value of the letter code is a character string from the table below.
Data type | Return Value |
---|---|
ARRAY (STATIC) | A |
ARRAY (DYNAMIC) | O |
BIGINT | N |
BIT | L |
BYTE | N |
CHARACTER | C |
CURRENCY | Y |
DATE | D |
DATETIME | T |
DECIMAL | N |
DOUBLE | N |
FLOAT | N |
GENERAL | G |
INTEGER | N |
LOGICAL | L |
LONG VARCHAR | M |
LONG VARBINARY | G |
MEDIUMINT | N |
MEMO | M |
NUMERIC | N |
OBJECT | O |
PACKED | N |
QUAD | N |
REAL | N |
SHORT | N |
SMALLINT | N |
Syntax error | U |
TEXT | M |
TIME | C |
TIMESTAMP | T |
TINYINT | N |
Undefined | U |
VAXDATE | C |
VARCHAR | C |
ZONED NUMERIC | C |
Example
i = 10 ? type("i") N