Sorting is not work for double Field Type

[Abhijit Shivathare]

I have store the timestamp in onDt column as 

var d = new Date();

var timestamp = Math.floor(d.getTime() / 1000);

select query use order by on onDt column. Which give me wrong result 

[Roberto Franchini]

Is onDt column defined as a DATE or DATETIME in the database schema? 

--

Best regards,

 

Roberto Franchini

OrientDB LTD  -  http://orientdb.com