EJB design: MySql Date retrieving format
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...
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