Time element

I'm currently having code problem with my search result page. The time field element is displaying incorrectly.

When I insert time (04:00 PM) into the time field. The result.php display it like this (04:00 am) it seem like (am) is the defaults.

Please help.
Sharach

the MySQL Time column type takes the time in the following form at:
hh:mm:ss

it does not recognize am or pm, the time is in 24 hour format, 4:00pm should be sent tot the database as 16:00


if you wish to use 4:00pm in the database, you should be using a varchar column type, not a time column type.

Hello Jason,

I’m currently working with a sport schedule website, the admin inserts sports schedule in backend of the site and clients search the schedule and than print out a copy.

The problem is when the admin enter the schedule information including the date into the database as 10:00 PM and submit the data. The update.php / result.php pages output and display as 10:00 am instead of 10:00PM.


Ray Borduin had helped me with these issues, but some how doing the testing I find out that the display were incorrect.

Technical Support Ticket # 123060
Technical Support Ticket # 123143
Technical Support Ticket # 123479

it is because you are using a time column type.

use a varchar column type instead.

Thanks Jason,

I change the column type to varchar and it working.

I want to force the pm column to be UPPERCASE but can't figure out how to do it. Any help is GREATLY appreciated << ...


Thanks
Sharach

dont worry about the format in the database, force it to upper case when displaying it on the page at run by using strtoupper():

<?php echo strtoupper($row_RecordsetName['ColumnName']); ?>