I had problem in displaying datetime using select statement.
I have TimeIn and TimeOut with datatype DateTime
I want to display it (dd-mm-yyyy) and the hours is 12 hours with AM and PM.
now it display:
TimeIn: 2011-10-24 05:35:00
TimeOut: 2011-10-24 13:35:00
this is my code:
$sql = "SELECT EMP_NO, TimeIn, TimeOut FROM attendance WHERE Date BETWEEN '$DATE1' AND '$DATE2'";
I want to display the data
TimeIn: 24-10-2011 05:35 AM
TimeOut: 24-10-2011 014:35 PM
I tried to find syntax for that but it did not match on what format i want.