Displaying MySQL database with DATE_FORMAT

2001-06-01 Thread Tim Thorburn
Hi, I've developed a simple search engine for a site I'm working on. Its purpose is to display community events based on the users input criteria. The problem is, if I use the DATE_FORMAT command to alter the appearance of the events dates and times - then MySQL begins at the top of the list

Re: Displaying MySQL database with DATE_FORMAT

2001-06-01 Thread Eric Fitzgerald
') AS FormattedEventStartDate, TIME_FORMAT(EventStartTime, '%r') AS FormattedEventStartTime FROM comcal2001 WHERE blah - Original Message - From: Tim Thorburn [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 01, 2001 12:08 PM Subject: Displaying MySQL database with DATE_FORMAT Hi, I've developed