I look in to your test case you didn't create properties with types. Look in this scenario
CREATE CLASS TestClass CREATE PROPERTY TestCLass.someDate date CREATE PROPERTY TestCLass.someDateTime datetime INSERT INTO TestClass SET someDate = "1582-10-04 09:00:00", someDateTime = "1582-10-14 09:00:00" On Friday, December 19, 2014 12:09:32 PM UTC+2, Charles Pick wrote: > > Could not replicate this with Oriento, see this test case - > https://github.com/codemix/oriento/blob/gregorian-dates/test/bugs/xxx-gregorian-dates.js > > Charles > > On Thursday, December 18, 2014 9:05:47 PM UTC, GoorMoon wrote: >> >> Hello everyone, >> >> I check the driver fault in OrientDB-Net.binary with dates and I noticed >> that the dates in between 1582-10-04 and 1582-10-15 can not be inserted >> into the database. >> I understand that this happens because the Gregorian calendar that JAVA >> using. >> But I think the database must support all range of a dates at least from >> 0001-01-01 to 9999-12-31. >> WDYT? >> >> ============================================ >> >> orientdb {db=Temp}> info class testvertex >> >> Class................: TestVertex >> Default cluster......: testvertex (id=12) >> Supported cluster ids: [12] >> Cluster selection....: round-robin >> >> PROPERTIES >> >> -------------------------------+---------------------+----------------------------------------------+----------------------+-------------------+----------------+-------------+--------------+----------------+ >> NAME | TYPE | LINKED TYPE/CLASS >> | MANDATORY | READONLY | NOT NULL | MIN | MAX | COLLATE | >> >> -------------------------------+---------------------+----------------------------------------------+----------------------+-------------------+----------------+-------------+--------------+----------------+ >> _dt | DATETIME | null >> | false | false | false >> | | | default | >> >> -------------------------------+---------------------+----------------------------------------------+----------------------+-------------------+----------------+-------------+--------------+----------------+ >> >> orientdb {db=Temp}> select from testvertex >> >> ----+---------+----------------+------------------------------ >> # |@RID |@CLASS |_dt >> ----+---------+----------------+------------------------------ >> 0 |#12:0 |TestVertex |0001-01-01 00:00:00 >> ----+---------+----------------+------------------------------ >> >> 1 item(s) found. Query executed in 0.003 sec(s). >> orientdb {db=Temp}> insert into TestVertex set _dt='1582-10-14 00:00:00' >> >> Error: >> com.orientechnologies.orient.core.exception.OQueryParsingException: Error >> on conversion of date '1582-10-14 00:00:00' using the format: yyyy-MM-dd >> HH:mm:ss >> >> orientdb {db=Temp}> >> >> -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
