Yes, there is .. You can use %D (note that it is capital D) instead of %e to get what you wanna get.
See: http://www.mysql.com/doc/D/a/Date_and_time_functions.html Gurhan -----Original Message----- From: Lee P Reilly [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 5:51 PM To: MySQL 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 "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 --------------------------------------------------------------------- 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
