473,408 Members | 1,747 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,408 software developers and data experts.

To_char(to_date(1234567,'j'),'jsp

can anyone explain the query details
May 15 '07 #1
3 21260
Saii
145 Expert 100+
can anyone explain the query details
As there is no in built function in oracle to convert numerals to word, we use this select statement to do so though there are some limitations.

TO_CHAR(TO_DATE(numbertobeconverted,'J'),'JSP')

'J' stands for Julian date conversion (date to number), while 'JSP' stands for Julian dates SPelled.
May 15 '07 #2
can anyone explain the query details

Hi,
It will display the given number in expanded format like.......ONE MILLION TWO HUNDRED THIRTY-FOUR THOUSAND FIVE HUNDRED SIXTY-SEVEN....

regards,
May 16 '07 #3
debasisdas
8,127 Expert 4TB
J-is used to return -JULIAN-
i.e.--DAYS SINCE 31-DEC-4712 BC


SP is used to spell the day.

try executing the inner part of the query separately ,u can easily find out.
May 19 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Phil Powell | last post by:
Ok, I installed ANT, I have c:\ant in my ANT_HOME environment variable, I have c:\ant\bin in my PATH environmental variable, I installed the JAR files for TCL and for Javascript (Rhino)... to no...
2
by: Paul Lee | last post by:
Dear all, I've written a jsp which is very large and monolithic, and what I want to do is refactor it to provide functions that can operate on global jsp variables. For instance, what I have at...
2
by: Omar | last post by:
Hi, I've been trying to get the right way to send parameters to a JSP from a HTML form. The referred JSP must get the values of the selects form, because it executes queries and does stuff with...
8
by: rnvssudheer | last post by:
i am using a 2 jsp's, named first.jsp and details.jsp when i click on SHOW button of first.jsp, details.jsp must be invoked, this details.jsp has 3 buttons like PREVIOUS, NEXT, and BACK. BACK is...
1
by: jadeite100 | last post by:
Hi: I am using IE 6 SP2. My resize attribute does not work <body onresize="test1();">. When I resize my window, the resize event doesnot get call. I have a jsp page with an iFrame called...
13
by: honey99 | last post by:
Hi! I have to fix a problem in JSP.Actually,i have a JSP page say Ex1.jsp.In this Ex1.jsp i have an anchor tag which links into another JSP page i.e when i click on the link another pop-up window...
15
by: josh | last post by:
Hi, I'm a jsp programmer and I have changed work. My boss does not matter about my previous Java experience and so he told me to learn web programming using c#. I have also many Javascript/DOM...
1
by: bb72 | last post by:
Hello, I have a project using JSP and JSTL. I have to forward one JSP to another. The problem that I am having is understanding what JSTL tags to loop through and get the information from the java...
12
lifeisgreat20009
by: lifeisgreat20009 | last post by:
I am a newbie to Struts and JSP...I have been working on the code below for 5 hours now..I googled a lot but couldn't get much help so finally I am here.. Hoping of getting my problem solved. Please...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.