how can i convert date such as 20/03/2011 0r string 20032011 to twentieth march two thousand and eleven
rajeshgs
0
Newbie Poster
Recommended Answers
Jump to Postyou can use some built in string functions for a start.
but if you want that output, better have sub procedures that will generate the suffix for each word number.
Jump to Posttry this (oracle code)
select to_char(sysdate,'ddspth fmmonth yyyysp') from dual
If dates are being stored in oracle DB then you may use this.
All 5 Replies
jogieglenmait
0
Light Poster
debasisdas
580
Posting Genius
Featured Poster
rajeshgs
0
Newbie Poster
debasisdas
580
Posting Genius
Featured Poster
Coco Chanel
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.