Worked! Thank you Tobie!
On Thursday, February 12, 2015 at 3:54:42 PM UTC+1, Tobie Morgan Hitchcock wrote: > > You could also use > > select first( outE().timestamp ) as created_time, first( inE().timestamp ) > as closed_time > > > http://www.orientechnologies.com/docs/last/orientdb.wiki/SQL-Functions.html#first > > Tobie > > On Thursday, 12 February 2015 14:49:43 UTC, Tobie Morgan Hitchcock wrote: >> >> Hi Rubens, >> >> The thing about in(), out(), both(), inE(), outE(), inV(), outV() is that >> it should return an array of records (edges/vertices) and not a single >> value. >> >> To get the first edge from the query and ignore the other edges you could >> use the following... >> >> select outE()[0].timestamp as created_time, inE()[0].timestamp as >> closed_time >> from Ticket >> where id='1' >> >> That will take the first item in the array of returned edges, giving you >> the timestamp field as a datetime. >> >> Maybe there is another better way that I don't know of, but that should >> work I think. >> >> Tobie >> >> On Thursday, 12 February 2015 14:20:52 UTC, Rubens Ballabio wrote: >>> >>> Hi Tobie, >>> >>> the query i am doing is not retrieving datetime... that's the real issue. >>> This is my query: >>> >>> select outE().timestamp as created_time, inE().timestamp as closed_time >>> from Ticket >>> where id='1' >>> >>> the output i see is something like this: >>> ["2014-10-24 09:14:17"], ["2014-10-26 19:31:23"] >>> >>> basically i am getting the timestamps from two different edges connected >>> to one Vertex. >>> Maybe this query is not the best option. >>> >>> Can You advice me? >>> Best >>> Rubens >>> >>> >>> On Thursday, February 12, 2015 at 2:35:54 PM UTC+1, Tobie Morgan >>> Hitchcock wrote: >>>> >>>> Hi Rubens, >>>> >>>> There should be a couple of ways of making it work... >>>> >>>> 1. This uses eval to give you the time difference in milliseconds >>>> SELECT eval('deleted_at - created_at') AS diff FROM Friends >>>> >>>> 2. This uses eval to give you the time difference in seconds >>>> SELECT eval('(deleted_at - created_at) / 1000') AS diff FROM Friends >>>> >>>> 3. Create a function and use that to give you the difference in >>>> milliseconds >>>> INSERT INTO OFunction SET name='diff', parameters=["datetime1", >>>> "datetime2"], language='groovy', code="return datetime1.getTime() >>>> - datetime2.getTime();" >>>> SELECT diff(deleted_at, created_at) AS diff from Friends >>>> >>>> >>>> On Thursday, 12 February 2015 13:14:06 UTC, Rubens Ballabio wrote: >>>>> >>>>> Hi guys, >>>>> >>>>> do you know if there is any way to do a simple difference between two >>>>> datetime parameters? >>>>> i can't find the way to make it work. >>>>> >>>>> thank you in advance, >>>>> Rubens >>>>> >>>> -- --- 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 orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
