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?