EJB design: MySql Date retrieving format

  1. MySql Date retrieving format (1 messages)

    hi buddies i have one problem.. it is possible to retrive the date from MySql in the format 23rd june 2007. but i need the suffix (rd) after date as superscript.. is it possible.. we have to retrieve the result from the query.. can any one help me...
  2. Re: MySql Date retrieving format[ Go to top ]

    MySql gives you a date representation. However, how you choose to format the date into text is beyond MySql. Do you want to format the date directly in the query result (through a sql client), or prehaps in a java app? /Niklas