RE: date_format question

Subject: date_format question Hi, I have a quick question concerning date/time functions. If I query MySQL: SELECT date_format(date, '%W %M %e %Y') FROM experiments where expid=3706 It returns: Wednesday May 2 1979 Are there existing methods for determining whether to add &qu

date_format question

Hi, I have a quick question concerning date/time functions. If I query MySQL: SELECT date_format(date, '%W %M %e %Y') FROM experiments where expid=3706 It returns: Wednesday May 2 1979 Are there existing methods for determining whether to add "st", "nd" or "rd" after the %e? e.g. in thi