mysql datew time code example Example: mysql get time from datetime SELECT date_format(datecol, '%H:%i:%s') as 'time' FROM table; -- eg. 10:33:10