I'm using the mysql time format (00:00:00) in a db because I need to order the contents according to ascending time. The problem is that I want to display the times as 6:00 AM instead of 06:00:00, etc.

I've been playing around with several different ideas, but all have failed ultimately. Does anyone know of a good way to do this?

Thanks.

First problem i had with PHP and mySQL actually, so heres how to fix it.

PHP Code:

function convert_sqltotxt($time) {

    // Delimiters may be slash, dot, or hyphen
    list($hour, $min, $sec) = split('[/.-:]', $time);

    return(gmdate("h:j A", mktime($hour, $min, 0, 0, 0, 0)));

} 


where $time is the SQL format, the split will split any time with seperators / . - or :

This should work, im not too sure about using all them zero's though

check out the PHP Manual on mktime() and date()

Cool. I'll give this a shot and let everyone know how it works.

Thanks.