Technical Blog
Pages
(Move to ...)
Home
Oracle DBA
ERP
Oracle Apps
Data Warehouse
Java
UNIX
Hadoop
JOBS4U
▼
Showing posts with label
DIMENSION
.
Show all posts
Showing posts with label
DIMENSION
.
Show all posts
Jun 10, 2011
Convert a number to word
›
select to_char(to_date('1983','J'),'JSP') from dual; In this query the number is converting into Julian date then ...
Mar 9, 2009
JSP Format Model
›
To convert date into numbers and words select to_char(sysdate,'J') "WORDS" from dual; select to_date(to_char(sysdate...
›
Home
View web version