File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes query in oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "query in oracle" Watch "query in oracle" New topic

query in oracle

Phillipe Rodrigues
Ranch Hand

Joined: Oct 30, 2007
Posts: 165
How to get a date format in (dd-MON-CCYY) by writing a query in oracle.

CC- Century

Campbell Ritchie

Joined: Oct 13, 2005
Posts: 46412
Surely you use the SimpleDateFormat class or the %T tags to format the data after retrieval from the database?
Paul Campbell
Ranch Hand

Joined: Oct 06, 2007
Posts: 338
or use TO_CHAR(column_with_date,"dd-mon-yyyy") in your query.
I agree. Here's the link:
subject: query in oracle
It's not a secret anymore!