Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
The moose likes JDBC and the fly likes to_char in mysql 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 "to_char in mysql" Watch "to_char in mysql" New topic

to_char in mysql

sravani gogineni
Ranch Hand

Joined: Feb 09, 2011
Posts: 33
i need to re write my sql statments from oracle to mysql.
could you please let me know what is to_char in msql.

Jeanne Boyarsky
internet detective

Joined: May 26, 2003
Posts: 30057

There is a format() function. to_char can convert from different source formats and the way to do it would vary though. What to_char() parameters do you have now?

[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: to_char in mysql
Similar Threads
WA #1.....word association
Advice of database type is needed
getting last row
Using datasource in netbeans to get connection
Inserting the Date in to MySQL