Solved

date format

Posted on 2012-04-13
3
517 Views
Last Modified: 2012-04-13
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?
0
Comment
Question by:SANbuddies
  • 2
3 Comments
 
LVL 13

Accepted Solution

by:
Ashok earned 500 total points
ID: 37842387
SELECT TO_CHAR(b, 'YYYY/MM/DD') AS myDate
FROM myTable;

HTH
Ashok
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 37842392
Dates have no format, to give them one:

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

or
set NLS_DATE_FORMAT.
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 37842399
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to recover a database from a user managed backup

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now