sqlite> select empid,strftime('%d-%m-%Y %w %W',updatedon) from employee where empid=104; 104|20-08-2015 4 33