javascript websql date formatting function
===

I've got a date column in my websql table that's currently in d-m-y format. What I'm trying to do is to convert this into "mm-dd-YYYY" format. Below is a test I'm running but the temp column remains empty after the below code is run. Is there an issue in my syntax?
 

tx.executeSql('update myTimes set temp = strftime("%m-%d-%Y", thedate)');

Thanks for your assistance