List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:September 28 1999 8:14am
Subject:Re: TIME shortcut
View as plain text  
On Tue, 1999-09-28 10:49:33 +0300, Bogdan Paduraru wrote:
> I have a small question : I have a table with a field of TIME type, but
> when you make a query I want to show the field like 'hh:mm' and not like
> it is this type ("hh:mm:ss)...I don't care about seconds.

Please, check out the description of TIME_FORMAT in chapter
"7.3.11 Date and time functions" of the MySQL Reference Manual.

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
TIME shortcutbpaduraru28 Sep
  • Re: TIME shortcutMartin Ramsch28 Sep