Home » SQL & PL/SQL » SQL & PL/SQL » Date with suffix in top (oracle 10g)
Date with suffix in top [message #358251] Mon, 10 November 2008 06:15 Go to next message
Messages: 325
Registered: August 2006
Senior Member

Can i get the date in the below format with suffix.
20th(The "th" should be in top of 20) DECEMBER 2008
with suffix for 20.I am unable to show the suffix in above case.It just comes as 20th. I want "th" as suffix in the top of 20. the same it shows in word document.

Can we do this in oracle, while inserting into database.

Re: Date with suffix in top [message #358259 is a reply to message #358251] Mon, 10 November 2008 06:27 Go to previous messageGo to next message
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Search for superscript in oracle reference manual.


Re: Date with suffix in top [message #358271 is a reply to message #358251] Mon, 10 November 2008 08:04 Go to previous message
Michel Cadot
Messages: 63908
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle manages data, your application manages display.
Don't ask a hammer to screw.


[Updated on: Mon, 10 November 2008 08:05]

Report message to a moderator

Previous Topic: What is the best tool for generating DDL of entire database?
Next Topic: Date data type
Goto Forum:

Current Time: Fri Oct 21 08:48:06 CDT 2016

Total time taken to generate the page: 0.05628 seconds