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