Database.Guide

Skip to content

Beginners

  • What is a Database?
  • Database Tutorial

SQL

  • SQL Tutorial
  • SQL Reference
  • SQL Joins Tutorial
  • SQL Transactions Tutorial
  • Basic SQL Queries

Categories

  • Azure SQL Edge (17)
  • Database Concepts (99)
  • Database Tools (72)
  • DBMS (9)
  • DuckDB (143)
  • MariaDB (424)
  • Microsoft Access (17)
  • MongoDB (265)
  • MySQL (602)
  • NoSQL (8)
  • Oracle (301)
  • PostgreSQL (480)
  • Redis (210)
  • SQL (697)
  • SQL Server (1,170)
  • SQLite (298)

Category: NoSQL

MongoDB $toObjectId

Posted on February 2, 2021February 2, 2021 by Ian

From MongoDB 4.0, you can use the $toObjectId aggregation pipeline operator to convert a string to an ObjectId.

The string must be a hexadecimal string of length 24.

Continue reading →
MongoDB aggregation, convert, operators, what is

MongoDB $rtrim

Posted on February 1, 2021February 1, 2021 by Ian

In MongoDB, the $rtrim aggregation pipeline operator removes whitespace from the end of a string. This includes the null character.

It can also remove any character specified. For example, you could use it to remove all periods (.), exclamation marks (!), etc from the end of a string.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $ltrim

Posted on February 1, 2021February 1, 2021 by Ian

In MongoDB, the $ltrim aggregation pipeline operator removes whitespace from the beginning of a string. This includes the null character.

It can also remove any character specified. For example, you could use it to remove all hyphen characters (-) from the beginning of a string.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $trim

Posted on February 1, 2021February 1, 2021 by Ian

In MongoDB, the $trim aggregation pipeline operator removes whitespace from the beginning and end of a string. This includes the null character.

It can also remove any character specified. For example, you could use it to remove all hyphen characters (-) or periods (.) or all s characters, etc.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB Whitespace Characters

Posted on January 31, 2021January 31, 2021 by Ian

The following table contains a list of whitespace characters that MongoDB removes by default when using the $trim, $ltrim, and $rtrim aggregation pipeline operators.

Continue reading →
MongoDB aggregation, reference

MongoDB $toLong

Posted on January 31, 2021January 31, 2021 by Ian

From MongoDB 4.0, you can use the $toLong aggregation pipeline operator to convert a value to a long.

Continue reading →
MongoDB aggregation, convert, operators, what is

MongoDB $toInt

Posted on January 31, 2021January 31, 2021 by Ian

From MongoDB 4.0, you can use the $toInt aggregation pipeline operator to convert a value to an integer.

Continue reading →
MongoDB aggregation, convert, operators, what is

MongoDB $toDouble

Posted on January 30, 2021January 30, 2021 by Ian

From MongoDB 4.0, you can use the $toDouble aggregation pipeline operator to convert a value to a double.

Continue reading →
MongoDB aggregation, convert, operators, what is

MongoDB $toDecimal

Posted on January 30, 2021January 30, 2021 by Ian

From MongoDB 4.0, you can use the $toDecimal aggregation pipeline operator to convert a value to a decimal.

Continue reading →
MongoDB aggregation, convert, operators, what is

MongoDB $toBool

Posted on January 29, 2021January 30, 2021 by Ian

From MongoDB 4.0, you can use the $toBool aggregation pipeline operator to convert a value to a boolean.

Continue reading →
MongoDB convert, operators, what is
  • «
  • 1
  • …
  • 35
  • 36
  • 37
  • 38
  • 39
  • …
  • 49
  • »

About Database.Guide | Privacy Policy