Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.snowflake.com/sql-reference/functions/system_typeof below:

Website Navigation

• Reference
• Function and stored procedure reference
• System

SYSTEM$TYPEOF | Snowflake Documentation

Categories:

System functions (System Information)

Returns a string representing the SQL data type associated with an expression.

See also:

TYPEOF

expr

The argument can be a column name or a general expression.

Returns a VARCHAR value that contains the data type of the input expression, for example, BOOLEAN, NUMBER, ARRAY, OBJECT, etc.

• If TYPEOF is executed without the SYSTEM$ prefix (i.e. as a regular function rather than a system function), it returns different results (see TYPEOF).

SELECT SYSTEM$TYPEOF(NULL);

Copy

+---------------------+
| SYSTEM$TYPEOF(NULL) |
|---------------------|
| NULL[LOB]           |
+---------------------+

+------------------+
| SYSTEM$TYPEOF(1) |
|------------------|
| NUMBER(1,0)[SB1] |
+------------------+

SELECT SYSTEM$TYPEOF(1e10);

Copy

+---------------------+
| SYSTEM$TYPEOF(1E10) |
|---------------------|
| NUMBER(11,0)[SB8]   |
+---------------------+

SELECT SYSTEM$TYPEOF(10000);

Copy

+----------------------+
| SYSTEM$TYPEOF(10000) |
|----------------------|
| NUMBER(5,0)[SB2]     |
+----------------------+

SELECT SYSTEM$TYPEOF('something');

Copy

+----------------------------+
| SYSTEM$TYPEOF('SOMETHING') |
|----------------------------|
| VARCHAR(9)[LOB]            |
+----------------------------+

SELECT SYSTEM$TYPEOF(CONCAT('every', 'body'));

Copy

+----------------------------------------+
| SYSTEM$TYPEOF(CONCAT('EVERY', 'BODY')) |
|----------------------------------------|
| VARCHAR(9)[LOB]                        |
+----------------------------------------+

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4