Sqlite: select ('now') not works as expected... I guess

I want to get the current date as yyyy-MM-dd from sqlite, I use the following query:

***SELECT date('now')***

But instead of return the current date. It returns the next day from today.

For example, today (2015-12-01) I run the query and it returns (2015-12-02).

What I did wrong?

Image running query + calendar