In MongoDB, the $cosh aggregation pipeline operator returns the hyperbolic cosine of a value that is measured in radians.
$cosh accepts any valid expression that resolves to a number.
The $cosh operator was introduced in MongoDB 4.2.
Author: Ian
MongoDB $asin
In MongoDB, the $asin aggregation pipeline operator returns the arcsine (inverse sine) of a value, measured in radians.
$asin accepts any valid expression that resolves to a number between -1 and 1.
The $asin operator was introduced in MongoDB 4.2.
3 Ways to Get the Job Steps of a SQL Server Agent Job (T-SQL)
In this article, I present three options for returning the steps of a SQL Server Agent job when using T-SQL.
Continue readingMongoDB $divide
In MongoDB, the $divide aggregation pipeline operator divides one number by another and returns the result.
To use $divide, pass the numbers in an array. The $divide operator will divide the first number by the second number. In other words, the first number is the dividend, and the second number is the divisor.
The arguments can be any valid expression as long as they resolve to numbers.
Continue readingMongoDB $multiply
In MongoDB, the $multiply aggregation pipeline operator multiplies numbers together and returns the result.
To use the $multiply operator, pass the numbers to the operator in an array.
The arguments can be any valid expression, as long as they resolve to numbers.
Continue readingMongoDB $subtract
In MongoDB, you can use the $subtract aggregation pipeline operator to subtract numbers and/or dates.
MongoDB $add
In MongoDB, the $add aggregation pipeline operator adds values together. Such values can be numbers, or they can be numbers and a date.
The $add operator accepts the values as arguments. The arguments can be any valid expression as long as they resolve to either all numbers or to numbers and a date.
3 Ways to Extract the Month from a Date in SQL Server (T-SQL)
Here are three T-SQL functions that you can use to extract the month from a date in SQL Server.
Continue readingMongoDB $anyElementTrue
In MongoDB, the $anyElementTrue aggregation pipeline operator evaluates an array as a set and returns true if any of the elements are true.
If none of the elements is true, then it returns false.
An array’s element is true if it’s not false, null, 0, or undefined.
MongoDB $allElementsTrue
In MongoDB, the $allElementsTrue aggregation pipeline operator evaluates an array as a set and returns true if no element in the array is false.
If the array contains an element that is false, then $allElementsTrue returns false.
An array’s element is true if it’s not false, null, 0, or undefined.