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
srinivas.k2005
Messages: 404
Registered: August 2006
Senior Member
Hi,

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
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Search for superscript in oracle reference manual.

Regards

Raj
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: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Oracle manages data, your application manages display.
Don't ask a hammer to screw.

Regards
Michel

[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: Tue Feb 11 01:55:35 CST 2025