This week's book giveaway is in the JavaScript forum.
We're giving away four copies of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js and have Paul Jensen on-line!
See this thread for details.
Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

query in oracle  RSS feed

 
Phillipe Rodrigues
Ranch Hand
Posts: 165
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How to get a date format in (dd-MON-CCYY) by writing a query in oracle.

CC- Century
 
Campbell Ritchie
Sheriff
Posts: 55350
157
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Surely you use the SimpleDateFormat class or the %T tags to format the data after retrieval from the database?
 
Paul Campbell
Ranch Hand
Posts: 338
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
or use TO_CHAR(column_with_date,"dd-mon-yyyy") in your query.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!