brady.k — Thu, 05 Feb 2004 00:31:03 +0000

Wait...there was somethinig about PHP that I thought and read about...and I was right!?!? No way....

Lol, yea it works fine. Thanks.

Suzanne — Sun, 01 Feb 2004 05:08:07 +0000

Well, fancy that, lol. Serves me right for posting on a Saturday and not paying attention. Did you get the problem solved?

brady.k — Sun, 01 Feb 2004 01:17:19 +0000

if there is no time format function...

Quote: TIME_FORMAT(time,format)
This is used like the DATE_FORMAT() function, but the format string may contain only those format specifiers that handle hours, minutes, and seconds. Other specifiers produce a NULL value or 0. If the time value contains an hour part that is greater than 23, the %H and %k hour format specifiers produce a value larger than the usual range of 0..23. The other hour format specifiers produce the hour value modulo 12:

mysql> SELECT TIME_FORMAT('100:00:00', '%H %k %h %I %l');
-> '100 100 04 04 4'

(same document you posted)

thanks.

Suzanne — Sat, 31 Jan 2004 23:26:54 +0000

http://www.mysql.com/doc/en/Date_and_time_functions.html

<?php
$sql = mysql_query(\"SELECT DATE_FORMAT(time, '%l:%i %p')\");
?>

There is no TIME_FORMAT() function.

Of course, if your field isn't a TIME, DATE, DATETIME, or TIMESTAMP field, you may have issues.

xxgeek — Sat, 31 Jan 2004 21:27:20 +0000

Not exactly sure if this works but give it a shot:

<?php
$sql = \"SELECT DATE_FORMAT(time,'%b %D, %Y at %T hrs')
?>

hope it helps...

ohh i think this should be
:

<?php
$sql = \"SELECT DATE_FORMAT(time,'%T hrs')
?>