MySQL Forums
Forum List  »  Newbie

Convert 12hour to 24 hour format
Posted by: Bradley Ammerman
Date: March 17, 2010 09:30AM

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.

Options: ReplyQuote

Written By
Convert 12hour to 24 hour format
March 17, 2010 09:30AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.