New Paste

Content

CREATE OR REPLACE FUNCTION f_words_usd(p_number NUMERIC)
RETURNS VARCHAR AS $$
DECLARE
    TYPE myArray IS ARRAY[1:13] OF VARCHAR;
    l_str myArray := ARRAY['', 'thousand', 'million', 'billion', 'trillion', 'quadrillion', 'quintillion', 'sextillion', 'septillion', 'octillion', 'nonillion', 'decillion', 'undecillion', 'duodecillion'];

l_num VARCHAR := TRUNC(p_number)::VARCHAR;
    l_return TEXT := '';
    l_decimal NUMERIC;
    l_return_decimal TEXT := '';
BEGIN
    -- Calculate decimal part
    l_decimal := p_number - TRUNC(p_number);
    
    FOR i IN 1 .. array_length(l_str, 1) LOOP
        EXIT WHEN l_num IS NULL OR l_num = '';

IF (SUBSTR(l_num, LENGTH(l_num) - 2, 3)::INT <> 0) THEN
            l_return := TO_CHAR(TO_DATE(SUBSTR(l_num, LENGTH(l_num) - 2, 3)::INT, 'J'), 'Jsp') 
                        || ' ' || l_str[i]
                        || CASE WHEN i != 1 THEN ' ' ELSE '' END
                        || l_return;
        END IF;

l_num := SUBSTR(l_num, 1, LENGTH(l_num) - 3);
    END LOOP;

IF l_return IS NOT NULL THEN
        l_return := l_return || ' US Dollar ';
    END IF;

-- Handle decimal part
    IF l_decimal != 0 THEN
        l_decimal := l_decimal * 100;
        l_return_decimal := TO_CHAR(TO_DATE(l_decimal::INT, 'J'), 'Jsp');
        l_return := l_return || ' and ' || l_return_decimal || ' Cents ';
    END IF;

IF l_return IS NOT NULL THEN
        l_return := l_return || 'Only';
    END IF;

RETURN l_return;
END;
$$ LANGUAGE plpgsql;

Optional Paste Settings

Title

Select folder or

Syntax Highlighting

Paste Expiration

Paste Status

Password

Description

Our statistics

Create and share texts quickly and easily 🚀

336,465+

Total pastes

172,653,711+

Total views

124+

Registered users

Our features

Everything you need 😉

Pastes creation

Create multiple posts quickly and easily with our powerful editor.

Folders

Store your pastes in different folders with custom names.

Paste protection

Protect your pastes with password, encryption and captcha.

Multiple syntax languages

We have 150+ syntax languages for your codes.

URL monetization

Earn money by enabling url shorteners in your pastes.

Global settings

Configure each aspect of your pastes globally.

Recent Pastes

A mix of both Western european3 Coordination luminophore Standing on T
HTML | 0.9K | 2 minutes ago
Multiply by 4 Part involving Pd Catalyst in Domino Reaction Regarding
HTML | 378 | 2 minutes ago
If purchasing a desktop data processor is something you conceive to be
HTML | 555 | 3 minutes ago
15 Best Pinterest Boards Of All Time About Wood Burners
HTML | 1K | 4 minutes ago
Responding to the role involving edaravone within the treating amyotro
HTML | 0.9K | 4 minutes ago
Give back Time period Look at the biggest Feasible Quake Magnitudes th
HTML | 265 | 4 minutes ago
The Key Manual to Comprehending Sustainable Power Sources
HTML | 682 | 5 minutes ago