MongoDB
Query by data type
Select all documents in the inventory collection where the price field value is a Double.
1 db.inventory.find( { price: { $type : 1 } } )
Select all documents in the inventory collection where the datex field value is a Date.
1 db.inventory.find( { datex: { $type : 9 } } )
Data types
Type |
Number |
Double |
1 |
String |
2 |
Object |
3 |
Array |
4 |
Binary data |
5 |
Undefined (deprecated) |
6 |
Object id |
7 |
Boolean |
8 |
Date |
9 |
Null |
10 |
Regular Expression |
11 |
13 |
|
Symbol |
14 |
JavaScript (with scope) |
15 |
32-bit integer |
16 |
Timestamp |
17 |
64-bit integer |
18 |
Min key |
255 |
Max key |
127 |