In Oracle, the SIN() function returns the sine of its argument, where the argument is an angle expressed in radians.
MongoDB Aggregation Operators for Returning Date Parts
This article lists the various aggregation pipeline operators that can be used to return individual date parts from a Date object in MongoDB.
Continue readingPOWER() Function in Oracle
In Oracle, the POWER() function returns its first argument raised to the power of its second argument.
REMAINDER() Function in Oracle
In Oracle, the REMAINDER() function returns the remainder of its first argument divided by its second.
It’s similar to the MOD() function, except that it uses ROUND() in its calculation, whereas MOD() uses FLOOR() in its calculation.
4 Functions to Get the Hour from a Time Value in MariaDB
Below are 4 functions that enable you to return the hour from a time value in MariaDB.
Continue readingMOD() Function in Oracle
In Oracle, the MOD() function returns the modulo operation. In other words, it returns the remainder of its first argument divided by its second.
EXP() Function in Oracle
In Oracle, the EXP() function returns the value of e (the base of natural logarithms) raised to the power of the argument.
The number e, also known as Euler’s number, is a mathematical constant approximately equal to 2.71828.
Continue readingReplace Multiple Characters in a String in SQL Server (T-SQL)
In SQL Server, the REPLACE() function enables us to replace a string with another string. But what if you want to replace a list of characters with another list of characters?
The TRANSLATE() function might help.
COSH() Function in Oracle
In Oracle, the COSH() function returns the hyperbolic cosine of its argument.
COS() Function in Oracle
In Oracle, the COS() function returns the cosine of its argument.