<font face="Verdana, Arial, Helvetica, sans-serif">
In Oracle's HTMLDB 10g, I tried to run the following statement:
SELECT 'Today is the ' || TO_CHAR(SYSDATE, 'Ddspth "of" Month, Year')
FROM DUAL;
I recieved as output...
'TODAYISTHE'||TO_CHAR(SYSDATE,'DDSPTH"OF"MONTH,YEAR')
Today is the Third of March , Two Thousand Six
So, weirdly enough, there's a space after the Month.
I tried fiddling with the it...
SELECT 'Today is the ' || TO_CHAR(SYSDATE, 'Ddspth "of" '|| RTRIM('Month', ' ') || ', Year')
FROM DUAL;
and some other wacky solutions. Nothing so far.
Does anyone have any ideas? Or knowledge of why this occurs? I'm about to chalk this up as another one of the quirky WTFs in Oracle's applications, but I just want to discuss it first. </font>
posted in The I-Hate-Oracle Club
SELECT 'Today is the ' || TO_CHAR(SYSDATE, 'Ddspth "of" Month, Year')
FROM DUAL;
I recieved as output...
'TODAYISTHE'||TO_CHAR(SYSDATE,'DDSPTH"OF"MONTH,YEAR')
Today is the Third of March , Two Thousand Six
So, weirdly enough, there's a space after the Month.
I tried fiddling with the it...
SELECT 'Today is the ' || TO_CHAR(SYSDATE, 'Ddspth "of" '|| RTRIM('Month', ' ') || ', Year')
FROM DUAL;
and some other wacky solutions. Nothing so far.
Does anyone have any ideas? Or knowledge of why this occurs? I'm about to chalk this up as another one of the quirky WTFs in Oracle's applications, but I just want to discuss it first. </font>