Thanks Niphold, its working as intended :) On Mon, Jul 16, 2012 at 3:55 PM, Niphlod <niph...@gmail.com> wrote:
> Why write such a query when DAL allows you to use a more (portable, > concise) pythonic way ? > > import datetime > yesterday = request.now - datetime.timedelta(days=1) > db(db.employee.created_on < yesterday).delete() > > > > On Monday, July 16, 2012 12:12:56 PM UTC+2, Amit wrote: >> >> Hi, >> I have created table Employe with following fields: >> db.define_table( >> 'Employee', >> Field('created_on','datetime', default=request.now), >> Field('emp_id'), >> Field('emp_age'), >> Field('emp_address), >> ) >> inserting data into the table is working fine but when i am trying to >> delete data one day older using below command: >> >> db.executesql('DELETE FROM db.Employee WHERE created_on < date_sub(now(), >> INTERVAL 1 DAY);') >> >> It's not working and i am not getting any error also, so can anybody help >> me resolve this issue. >> NOTE: I am using Sqlite database. >> >> >> --