#9942: Exception: can't convert from BSON type EO0 E00 EOO to Date for month() in aggregate framework

slavakiev reported 2013-09-10T20:41:51Z · last modified 2013-09-16T21:08:46Z

Dev	emil.goicovici
QA	tariqrahiman

Priority	Minor
Complexity	Unknown

Component	MongoSQL
Version	14.0

Tested Aqua Data Studio Aqua Data Studio 14.0.0-rc-13 Build #: 33892 on Ubuntu 12.04( Mongo DB 2.4.3)

drop collection orddate

insert into orddate(dates,funds) values(isoDate('2012-12-12T19:18:12.977Z'),10)

insert into orddate(dates,funds) values(isoDate('2012-12-13T19:18:12.977Z'),11)

insert into orddate(dates,funds) values(isoDate('2012-10-14T19:18:12.977Z'),1)

insert into orddate(dates,funds) values(isoDate('2012-10-2T19:18:12.977Z'),5)

select dates,month(dates) from orddate group by dates

--Exception occurred during aggregation: exception: can't convert from BSON type EO0 E00 EOO to Date

select month(dates) from orddate

--works correct

select * from orddate

All Comments (1) Change History

slavakiev 2013-09-16T21:08:46Z

Verified in Aqua Data Studio 14.0.0-rc-20 Build #: 33993 on Ubuntu 12.04( Mongo DB 2.4.3)