| format date field [message #374935] |
Thu, 12 July 2001 07:00  |
serdar
Messages: 4
Registered: July 2001
|
Junior Member |
|
|
I need to format a date to return dd-month-yyyy, e.g. 28-July-2001
The original format is 2001-07-28 00:00:00.00
|
|
|
|
|
|
| Re: format date field [message #374938 is a reply to message #374935] |
Thu, 12 July 2001 07:15  |
GIRIDHAR KODAKALLA
Messages: 92
Registered: May 2001
|
Member |
|
|
Hai Serdar,
SQL> SELECT TO_CHAR(TO_DATE('2001-07-28 00:00:00','YYYY-MM-DD HH24:MI:SS'),'DD-MONTH-YYYY') MY_DATE
2 from dual;
MY_DATE
-----------------
28-JULY -2001
If we want to eliminate the space after july, i think there is one command something like Fm or something.
I dont remember it exactly. That will help you to format it properly.Kindly check the documentation for that.
Regards,
Giridhar Kodakalla
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
