To_char(to_date(1234567,'j'),'jsp

[parvathiganesan]

can anyone explain the query details

[Saii]

can anyone explain the query details

As there is no in built function in oracle to convert numerals to word, we use this select statement to do so though there are some limitations.

TO_CHAR(TO_DATE (numbertobeconv erted,'J'),'JSP ')

'J' stands for Julian date conversion (date to number), while 'JSP' stands for Julian dates SPelled.

[gangadharampidugu]

can anyone explain the query details

Hi,
It will display the given number in expanded format like.......ONE MILLION TWO HUNDRED THIRTY-FOUR THOUSAND FIVE HUNDRED SIXTY-SEVEN....

regards,

[debasisdas]

J-is used to return -JULIAN-
i.e.--DAYS SINCE 31-DEC-4712 BC


SP is used to spell the day.

try executing the inner part of the query separately ,u can easily find out.