Amazon Redshift will no longer support the creation of new Python UDFs starting November 1, 2025.
If you would like to use Python UDFs, create the UDFs prior to that date.
Existing Python UDFs will continue to function as normal. For more information, see the
blog post
DLOG10 function
The DLOG10 returns the base 10 logarithm of the input parameter.
Synonym of LOG function.
Syntax
DLOG10(number)
Argument
- number
-
The input parameter is a
DOUBLE PRECISION
number.
Return type
DOUBLE PRECISION
Example
To return the base 10 logarithm of the number 100, use the following example.
SELECT DLOG10(100);
+--------+ | dlog10 | +--------+ | 2 | +--------+