How to modify the date format of date('now') in sqlite?

When I execute the following query : select date('now') It returns 2015-07-08. But, I want to receive date in the format mm/dd/yyyy like 08/07/2015. How can I do that?

I know it sounds like a stupid question, but I'm not able to figure it out for so long.