Page 1 of 1

DATE format in MySQL

Posted: Thu Jun 24, 2004 3:28 am
by Calimero
what is the code to insert when designing the table so the MySQL shows

18:30:00,

and not to show (as it does right now)

6:30:00 PM

Thanks ahead!

Posted: Thu Jun 24, 2004 3:46 am
by feyd
having a TIME/DATETIME/TIMESTAMP column type will display 24hr format.

Well... it doesn't

Posted: Fri Jun 25, 2004 5:41 am
by Calimero
MySQL 4.0.18 or something like that, Win XP

it gives 6:20:00 PM

and I would need 18:20:00

Thanks Ahead!

Posted: Fri Jun 25, 2004 6:55 am
by magicrobotmonkey
is it a DATETIME field?

Posted: Fri Jun 25, 2004 8:20 am
by Buddha443556
Are you using a front-end of some kind to design your table? Like PHPMyAdmin or MySQL-Front?