In MariaDB, DIV performs integer division.
It discards from the division result any fractional part to the right of the decimal point.
How ABS() Works in MariaDB
In MariaDB, ABS() is a built-in numeric function that returns the absolute (non-negative) value of its argument.
8 Ways to Add Microseconds to a Datetime Value in MariaDB
If you need to add one or more microseconds to a datetime value in MariaDB, here are 8 options to consider.
How ROUND() Works in MariaDB
In MariaDB, ROUND() is a built-in numeric function that rounds its argument to a given number of decimal places.
How ASIN() Works in MariaDB
In MariaDB, ASIN() is a built-in numeric function that returns the arcsine (inverse sine) of its argument.
In other words, it returns the value whose sine is the argument.
How to do an INSERT Pass-Through Query in SQL Server
In SQL Server, you can use OPENQUERY to execute a pass-through query on a linked server.
OPENQUERY is commonly referenced in the FROM clause of a query as if it were a table, but it can also be referenced as the target table of an INSERT, UPDATE, or DELETE statement.
This article presents an example of using OPENQUERY to do an INSERT pass-through query.
How RAND() Works in MariaDB
In MariaDB, RAND() is a built-in function that returns a random DOUBLE precision floating point value v in the range 0 <= v < 1.0.
How ACOS() Works in MariaDB
In MariaDB, ACOS() is a built-in numeric function that returns the arccosine (inverse cosine) of its argument.
In other words, it returns the value whose cosine is the argument.
3 Ways to Sort Documents in MongoDB
MongoDB provides a few ways to sort documents in a particular order. Each of these allow us to order the documents in ascending or descending order.
There’s also the option to order the results of a $text search – sorting by the computed textScore metadata in descending order.
Here are 3 ways to sort documents in MongoDB.