# BSON\_GET\_TYPE

Returns a string that specifies the BSON type of the input BSON value.

## Syntax

```
BSON_GET_TYPE(<input>)
```

## Argument

`<input>`: A valid BSON value or an expression that evaluates to a valid BSON value.

## Return Type

A string.

## Remarks

* If `NULL` is specified as the input value, returns `"null"` as the result.
* If the input is an invalid BSON value, returns `"missing"` as the result.

## Examples

**Note**: The following examples explicitly cast string to BSON for clarity.

```sql
SELECT BSON_GET_TYPE( '{"a":1, "b":2, "c":"abc"}':>BSON) AS Type;

```

```output

+--------+
| Type   |
+--------+
| object |
+--------+
```

```sql
SELECT BSON_GET_TYPE('[1, true, null, [7,8,9], "abc"]':>BSON) AS Type;

```

```output

+-------+
| Type  |
+-------+
| array |
+-------+
```

```sql
SELECT BSON_GET_TYPE('true':>BSON)  AS Type;

```

```output

+------+
| Type |
+------+
| bool |
+------+
```

```sql
SELECT BSON_GET_TYPE('"abc"':>BSON) AS Type;

```

```output

+--------+
| Type   |
+--------+
| string |
+--------+
```

```sql
SELECT BSON_GET_TYPE('null':>BSON) AS Type;

```

```output

+------+
| Type |
+------+
| null |
+------+
```

```sql
SELECT BSON_GET_TYPE("abc") AS Type;

```

```output

+---------+
| Type    |
+---------+
| missing |
+---------+
```

***

Modified at: April 3, 2024

Source: [/db/v9.1/reference/sql-reference/bson-functions/bson-get-type/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/bson-functions/bson-get-type/)

(An index of the documentation is available at /llms.txt)