<div>
Dates have no format, to give them one:<br />
<br />
to_char(date_column,'YYYY/<wbr />MM/DD')<br />
<br />
or<br />
set NLS_DATE_FORMAT.
</div>


Dates have no format, to give them one:

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

or
set NLS_DATE_FORMAT.

<div>
Here is the doc link for NLS_DATE_FORMAT:<br />
<a href="http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams144.htm" rel="ugc nofollow">http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams144.htm</a>
</div>


Here is the doc link for NLS_DATE_FORMAT:
http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams144.htm [http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams144.htm]

<div>
<div class="content wysiwyg-content">
It may sound a silly question but I am trying to achieve the following.<br />
<br />
<br />
-- 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,<br />
<br />
--I want to report it as YYYY/MM/DD and without the timestamp.<br />
<br />
Any suggestions?
</div>
</div>


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?

date format

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.