You can also use the date() and time() SQL function; select date(start_time) pull out just the date part; select time(start_time) pulls out just the time part.