Time in MYSQL

[ljCharlie]

Please help. I read the section about Time in MySQL website but still the page hasn't answered my question yet or perhaps I don'te quite get it yet. Is 15:56 translate to 3:56 PM? I guess the quesiton is what about AM and PM? When I retreive the value from MySQL to display on a web page, will the time display the PM and/or AM too or I'll have to do that manually?

Many thanks in advance!

ljCharlie

[raf]

Please don't start a new thread. You should have just posted in your other thread + be more specific with information

I suppose you read this
http://www.mysql.com/doc/en/DATETIME.html

To display it, you need to look at the scriptinglanguage you use (PHP or ASP or ...) Probably you'll had gotten faster feedback if you posted it there. If you use PHP, check out
the datatime functions here (like gmdate())
http://www.php.net/manual/en/ref.datetime.php

PM and AM ? Well, i never use that and i guess there are a lot of users that don't use it and get confused by it.