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 (153)
  • MariaDB (424)
  • Microsoft Access (17)
  • MongoDB (265)
  • MySQL (602)
  • NoSQL (8)
  • Oracle (301)
  • PostgreSQL (480)
  • Redis (210)
  • SQL (697)
  • SQL Server (1,170)
  • SQLite (299)

Tag: numeric functions

How SIN() Works in MariaDB

Posted on June 17, 2021 by Ian

In MariaDB, SIN() is a built-in numeric function that returns the sine of its argument, where its argument is provided in radians.

Continue reading →
MariaDB functions, numeric functions, what is

How PI() Works in MariaDB

Posted on June 15, 2021 by Ian

In MariaDB, PI() is a built-in function that returns the value of the number Ï€ (pi).

The number Ï€ is a mathematical constant. It is defined as the ratio of a circle’s circumference to its diameter, and it also has various equivalent definitions. It is approximately equal to 3.141593, although its decimal representation never ends.

Continue reading →
MariaDB functions, numeric functions, what is

How CRC32 Works in MariaDB

Posted on June 15, 2021 by Ian

In MariaDB, CRC32() is a built-in numeric function that computes a cyclic redundancy check value and returns a 32-bit unsigned value.

CRC32 is a popular checksum algorithm used to detect data corruption.

Continue reading →
MariaDB functions, numeric functions, what is

How LOG10() Works in MariaDB

Posted on June 14, 2021 by Ian

In MariaDB, LOG10() is a built-in function that returns the base-10 logarithm of its argument.

Continue reading →
MariaDB functions, numeric functions, what is

How LOG2() Works in MariaDB

Posted on June 14, 2021 by Ian

In MariaDB, LOG2() is a built-in function that returns the base-2 logarithm of its argument.

Continue reading →
MariaDB functions, numeric functions, what is

How TRUNCATE() Works in MariaDB

Posted on June 13, 2021 by Ian

In MariaDB, TRUNCATE() is a built-in numeric function that returns a given number, truncated to a given number of decimal places.

Continue reading →
MariaDB functions, numeric functions, what is

How ABS() Works in MariaDB

Posted on June 13, 2021 by Ian

In MariaDB, ABS() is a built-in numeric function that returns the absolute (non-negative) value of its argument.

Continue reading →
MariaDB functions, numeric functions, what is

How ROUND() Works in MariaDB

Posted on June 12, 2021June 13, 2021 by Ian

In MariaDB, ROUND() is a built-in numeric function that rounds its argument to a given number of decimal places.

Continue reading →
MariaDB functions, numeric functions, what is

How ASIN() Works in MariaDB

Posted on June 12, 2021 by Ian

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.

Continue reading →
MariaDB functions, numeric functions, what is

How RAND() Works in MariaDB

Posted on June 11, 2021June 12, 2021 by Ian

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.

Continue reading →
MariaDB functions, numeric functions, what is
  • «
  • 1
  • …
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • »

About Database.Guide | Privacy Policy