SELECT initcap(to_char(to_timestamp(substr(lpad(abs(123456789), 9, '0'),
1,
3),
'FF3'),
'FFSP') || ' ' ||
to_char(to_timestamp('000' ||
substr(lpad(abs(123456789), 9, '0'), 4),
'FF9'),
'FFSP'))
FROM dual;
1,
3),
'FF3'),
'FFSP') || ' ' ||
to_char(to_timestamp('000' ||
substr(lpad(abs(123456789), 9, '0'), 4),
'FF9'),
'FFSP'))
FROM dual;