Hello everyone,
I have a query that I am running and pulling time and dates out of my database and displaying data based on the time and date. My vendor does not want to change their code to be able to give me the file in 24 hour format. Is there a way to convert it from 12 hour to 24 hour? Basically if it says 01:00:00 I want it to be seen as 13:00:00 since we will never have any meetings at 01:00:00.
here is the data I am pulling
---------------------------------
2010-04-05 Justice Center 17th Floor En Banc 54675 SHERMAN (DONALD) VS. STATE 2010-04-05 10:00:00 30 min Mikael Smith
here is my query.
--------------------
mysql_select_db($database_intranet, $intranet);
$query_oralArg = "SELECT id, date_FORMAT(argumentDate, '%m,%d, %y') as newdate, argumentLocation, roomNumber, panelType, docketNumber, caseTitle, TIME_FORMAT(argumentTime, '%h:%i') as newTime, argumentLength, assignedPanelMembers FROM tblargcalendar ORDER BY argumentDate, argumentTime";
$oralArg = mysql_query($query_oralArg, $intranet) or die(mysql_error());
$row_oralArg = mysql_fetch_assoc($oralArg);
$totalRows_oralArg = mysql_num_rows($oralArg);
---------------------
Any help will be greatly appreciated.
Edited 2 time(s). Last edit at 03/17/2010 10:04AM by Bradley Ammerman.