Re: [sqlite] Problem with create table and strftime

2011-06-06 Thread Cecil Westerhof
2011/6/6 Igor Tandetnik : >> In a create table I have: >>      measureDate            DATE           UNIQUE      DEFAULT >> (strftime('%Y-%m-%d', 'now')), >> but when I look with .schema, I get: >>      measureDate            DATE           DEFAULT (Datetime('now')), >> >> The UNIQUE constraint is

Re: [sqlite] Problem with create table and strftime

2011-06-06 Thread Igor Tandetnik
Cecil Westerhof wrote: > In a create table I have: > measureDateDATE UNIQUE DEFAULT > (strftime('%Y-%m-%d', 'now')), > but when I look with .schema, I get: > measureDateDATE DEFAULT (Datetime('now')), > > The UNIQUE constraint is disappea