Case of column heading

[Shiva]

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.

[Shestakov]

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

[marist89]

SQL> select to_char(sysdate,'mm/dd/yyy') "sYsDaTe" from dual;

sYsDaTe
---------
05/13/002

SQL>

[Shiva]

Thanks Jeff.

Shiva.