displaying the date through sql query

[trysenthil]

hi all.,

i want a query from u.,which must display me like this.,

[for eg., select to_char(sysdate ,'dd-month-yyyy') from dual ]

is displaying me.,

07-september-2007

suppose i want a result as

seventh september 2007...... what will be the query for displaying this type of result.....

[debasisdas]

try the following

[CODE=oracle]select to_char(sysdate ,'ddspth month yyyy') from dual[/CODE]

[trysenthil]

thank you for your message thnk you very much