[sqlite] CURRENT_DATE, CURRENT_TIME and CURRENT_TIMESTAMP

BTW, the following with xxx(current_date,date) as ( select '2000-01-01',current_date ) select *,current_date,date from xxx; outputs: current_date datecurrent_date date -- -- 2000-01-012016-02-10 2016-02-102016-02-10 As

[sqlite] CURRENT_DATE, CURRENT_TIME and CURRENT_TIMESTAMP

Suggestion: Document the fact that CURRENT_DATE, CURRENT_TIME and CURRENT_TIMESTAMP are supported by SQLite on the Date And Time Functions page of the "SQL As Understood By SQLite" documentation. The only place you can currently find them is

[sqlite] CURRENT_DATE, CURRENT_TIME and CURRENT_TIMESTAMP

On 2/10/16, Eric Hill wrote: > Suggestion: Document the fact that CURRENT_DATE, CURRENT_TIME and > CURRENT_TIMESTAMP are supported by SQLite on the Date And Time > Functions page of the "SQL > As Understood By SQLite" documentation. The only