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 this case, it would instead read:
Wednesday May 2nd 1979
Thanks very much in advance for any help.
- Best regards,
Lee Reilly
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
