How does a mysql timestamp determine AM from PM? I'm using this for a news system and mysql can't recognize the difference between AM and PM. Should I not use mysql timestamp for my news articles?
MySql timestamp
It should be using a 24-hour clock if it's a timestamp or datetime type of column. If you want to output it in 12-hour format with an am/pm indicator, then you'll need to use the MySQL DATE_FORMAT() function in your query, or the PHP date() function.