Search notes:

Oracle SQL: Spell numbers

select
   to_char(date '-4712-01-01'      , 'Jsp') as one,
   to_char(date '-4712-01-01' +  41, 'Jsp') as forty_two,
   to_char(date '-4712-01-01' + 998, 'Jsp') as nine_nine_nine
from
   dual;

Github repository Oracle-patterns, path: /SQL/functions/type-conversion/format-models/spell-julian-day.sql

Spell first hundred numbers

The J stands for julian day, the SP for spell number.

select
   to_char(to_date(level, 'J'), 'JSP') num
from
   dual
connect by
   level <= 100;

Index