Fetch last 5 days record in orientdb

[Ramachandran Pandiyan]

Hi sir,

    Fetch last 5 days record in orientdb using date i am mention, please give query for that.. kindly need your help

    Example: 

     suppose i give date like '2015-01-06' so i want return that date minus 5 days record

    Waiting for your reply

   Thanks,

    Ram

[Dan Andrei]

I do something like this in python 

yesterday = datetime.now() - timedelta(days=1)

query2 = client.command("SELECT count(*) FROM User WHERE updated_at >= date('" + str(yesterday.strftime('%y-%m-%d')) + "', 'yyyy-MM-dd')")

Basically you have to get the "string" of '%y-%m-%d' then you just compare it to be bigger than "now()" 

[Ramachandran Pandiyan]

Thank you...

--

---
You received this message because you are subscribed to a topic in the Google Groups "OrientDB" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/orient-database/EG_fjs_CmzI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to orient-databa...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Thanks...

 Ram