[HELP] Order by date not working

[Academia Learning Centro de inglés y de formación]

I have tried with this query and I get this results (not ordered):

select value.uid.value as id, value.context.start_time.value as date

from CompositionVersions order by value.context.start_time.value desc limit 5

id	date
fe9e6036	2014-02-23T12:33:10.000+01:00
80eee423	2014-03-08T11:35:25.000+01:00
0600c7bd	2014-01-27T22:49:36.000+01:00
291c1e1e	2014-03-08T04:28:15.000+01:00
a8b7d7c9	2014-01-04T03:31:02.000+01:00

[Oleksandr Gubchenko]

Which version are you using?

[Ivan Mainetti]

please try with

select value.uid.value as id, value.context.start_time.value as date from CompositionVersions order by date desc limit 5

Il giorno martedì 29 novembre 2016 14:18:25 UTC+1, Academia Learning Centro de inglés y de formación ha scritto:

[Academia Learning Centro de inglés y de formación]

This says the console:

OrientDB console v.2.2.12-SNAPSHOT (build 2.2.x@r2a76ee1efc4487d9dc5f43e1ddc2fba

1c5a0167c; 2016-10-20 13:55:08+0000) www.orientdb.com

Type 'help' to display all the supported commands.

Installing extensions for GREMLIN language v.2.6.0

[Academia Learning Centro de inglés y de formación]

Thanks, this works