sqlite> select empid,datetime(updatedon,'localtime') from employee where empid=104;
104|2015-08-20 19:28:33