-
Hi all, just a curious question :
When retrieving the resultset from a SQL Query, is it possible to convert the case of the column heading displayed ? For
e.g., select sysdate from dual;
SYSDATE
---------
13-MAY-02
If I want to change the case of SYSDATE in the output,
I couldn't find a way to do it !! Is it really possible ?
Shiva.
-
SQL> select to_char(sysdate, 'dd-mon-rr') from dual;
TO_CHAR(S
---------
13-may-02
SQL> select to_char(sysdate, 'dd-Mon-rr') from dual;
TO_CHAR(S
---------
13-May-02
-
Code:
SQL> select to_char(sysdate,'mm/dd/yyy') "sYsDaTe" from dual;
sYsDaTe
---------
05/13/002
SQL>
Jeff Hunter
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|