This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes query in oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
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: 37958
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
Similar Threads
delete duplicate records
SQL Server limiting result set
A little SQL help with SUM()
time of Query Execution in Oracle ?
Oracle help