Explanation for the Query PLZZZZZ
-
Hi all i hav a query for which i got the result but i am not able to understand the query.... here's the query... select sal,to_char((to_date(sal,'j')),'jsp') from emp; Result: 3250 Three Thousand Two Hundred and Fifty. I just need the explanation of to_date and to_char command formats..... if possible can any one giv one example each on those two commands.. Thanks in Advance... Byee
-
Hi all i hav a query for which i got the result but i am not able to understand the query.... here's the query... select sal,to_char((to_date(sal,'j')),'jsp') from emp; Result: 3250 Three Thousand Two Hundred and Fifty. I just need the explanation of to_date and to_char command formats..... if possible can any one giv one example each on those two commands.. Thanks in Advance... Byee
TO_CHAR and TO_DATE are built-in functions in Oracle. TO_CHAR = Convert number to string TO_DATE = Convert string to date
-
TO_CHAR and TO_DATE are built-in functions in Oracle. TO_CHAR = Convert number to string TO_DATE = Convert string to date
i got ur point but how the given value is getting converted into words....
-
i got ur point but how the given value is getting converted into words....
Visit the following links, this will help you: http://www.techonthenet.com/oracle/functions/to_char.php[^] http://www.techonthenet.com/oracle/functions/to_date.php[^] http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96540/functions134a.htm[^] http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96540/functions137a.htm[^]