~drizzle-trunk/drizzle/development

Merge of Jay's work.

added added

removed removed

197

select quarter("0000-00-00"),quarter(d),quarter(dt),quarter(t),quarter(c) from t1;

198

--error 1686 # Argh. 0000-00-00 is not a date.

199

select year("0000-00-00"),year(d),year(dt),year(t),year(c) from t1;

200

select to_days("0000-00-00"),to_days(d),to_days(dt),to_days(t),to_days(c) from t1;

200

select to_days("0000-00-00"),to_days(d),to_days(dt),to_days(c) from t1;

201

--error 1686 # Ugh. bad datetime

202

select extract(MONTH FROM "0000-00-00"),extract(MONTH FROM d),extract(MONTH FROM dt),extract(MONTH FROM t),extract(MONTH FROM c) from t1;

203

drop table t1;