PDA

View Full Version : Timestamps & MySQL


SilverVenom
05-26-2007, 06:48 PM
Hi, I had a question about formatting the CURRENT_TIMESTAMP feature of MySQL. When I query the database with that I get a return of year-month-day hour:min:sec in respect to a 24 hour clock.

So my question was is there a way to have the date returned such as:

month-day-year hour-min-sec which the time is told using the 12 hour system? Thanks in advance! - Peter.