DATE format in MySQL

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Calimero
Forum Contributor
Posts: 310
Joined: Thu Jan 22, 2004 6:54 pm
Location: Milky Way

DATE format in MySQL

Post 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!
Last edited by Calimero on Fri Jun 25, 2004 5:39 am, edited 1 time in total.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

having a TIME/DATETIME/TIMESTAMP column type will display 24hr format.
User avatar
Calimero
Forum Contributor
Posts: 310
Joined: Thu Jan 22, 2004 6:54 pm
Location: Milky Way

Well... it doesn't

Post 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!
magicrobotmonkey
Forum Regular
Posts: 888
Joined: Sun Mar 21, 2004 1:09 pm
Location: Cambridge, MA

Post by magicrobotmonkey »

is it a DATETIME field?
User avatar
Buddha443556
Forum Regular
Posts: 873
Joined: Fri Mar 19, 2004 1:51 pm

Post by Buddha443556 »

Are you using a front-end of some kind to design your table? Like PHPMyAdmin or MySQL-Front?
Post Reply