Roberto Madro R.
asked on
Convert Number to date
"MYDATE" is a number field in an Oracle database, I'm converting it to date via the formula below, but I'm getting the output as follows;
03-Sep-13 12.00.00.00 AM,
I don't want the month spelled out, so I changed the upper "MM" to "mm", but to no avail, please advise.
to_DATE(MYDATE,'YYYYMMDD')
03-Sep-13 12.00.00.00 AM,
I don't want the month spelled out, so I changed the upper "MM" to "mm", but to no avail, please advise.
to_DATE(MYDATE,'YYYYMMDD')
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can display dates as strings in any format you can imagine.
Here is the doc link on all the different mask values:
http://docs.oracle.com/cd/E11882_01/server.112/e41084/sql_elements004.htm#SQLRF51079
Here is the doc link on all the different mask values:
http://docs.oracle.com/cd/E11882_01/server.112/e41084/sql_elements004.htm#SQLRF51079
ASKER
Right on the money. Thx
ASKER
Thank you.
" slightwvPosted on 2013-11-05 at 16:40:49ID: 39626049 "
" slightwvPosted on 2013-11-05 at 16:40:49ID: 39626049 "
ASKER