Heya, one solution could be
select DATE_FORMAT(date_time, '%T') from testtable; also check out EXTRACT which could help you for your other problem. http://www.mysql.com/doc/D/a/Date_and_time_functions.html EG ----- Original Message ----- From: "bob nt" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 25, 2002 11:15 AM Subject: time > hello, > 1) i have a value in a field in the db like > 2002-01-02 07:04:19(a date time field) > i cannot declare it as a time datatype as i need date > also be available in the field. > now is the myswl query to get just the time part from > the db? > > 2) Also if i sum up a field which is of time type from > a db using the query > ""select sum(t1) from testtable"" it rerurns some > thing like 93050 > > the values in the table are > 07:25:25 & 02:05:25 > it is just adding the hrs & min & sec but doesn't > display the hrs field as 09 & also doesn't display as > hh:mm:ss format. > is there any query in mysql to get these things in the > hh:mm:ss format. > plz respond me to [EMAIL PROTECTED] > > tnx > bobbie > > __________________________________________________ > Do You Yahoo!? > Yahoo! Games - play chess, backgammon, pool and more > http://games.yahoo.com/ > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php