Contributed by Calpont, InfiniDB Community Edition is an open source, scale-up analytics database engine for your data warehousing, business intelligence and read-intensive application needs. Enabled via MySQLTM and purpose-built for an analytical workload with column-oriented technology at its core, the multi-threaded capabilities of InfiniDB Community Edition fully encompass query, transactional support and bulk load operations.  So come on in, grab a download and get started.

             | 

Implicit conversion of integer values to date and datetime data types.

E-mail Print PDF

MySQL allows for integers to be implicitly (automatically) converted to date and datetime data types.  InfiniDB has incomplete support for automatically converting integers to date or datetime fields.

It is recommended that you use string representation when working with date and datetime data types, or use explicit conversions from integer to string representation of data.