date format

It may sound a silly question but I am trying to achieve the following.


-- How to change the data format reported by the database? currenty the date is reported as MM/DD/YYYY with the timestamp by the database,

--I want to report it as YYYY/MM/DD and without the timestamp.

Any suggestions?
SANbuddiesAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
AshokConnect With a Mentor Commented:
SELECT TO_CHAR(b, 'YYYY/MM/DD') AS myDate
FROM myTable;

HTH
Ashok
0
 
slightwv (䄆 Netminder) Commented:
Dates have no format, to give them one:

to_char(date_column,'YYYY/MM/DD')

or
set NLS_DATE_FORMAT.
0
 
slightwv (䄆 Netminder) Commented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.