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()" 



On Tuesday, January 6, 2015 9:35:19 AM UTC+2, Ramachandran Pandiyan wrote:
>
>
> 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
>

-- 

--- 
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.

Reply via email to