current datetime is: request.now or import datetime datetime.datetime.now()
Il giorno giovedì 19 luglio 2012 11:05:41 UTC+2, Amit ha scritto: > > Hi, > I have some records in a table and each record is having one field of type > datetime [fromat : 2012-07-19 23:12:0 (YYYY-MM-DD HH:MM:SS)], table > structure is: > > Emp_ID > Emp_Name > Emp_Address > Emp_Salary > updated_on(Type: datetime) > > periodically getting data against each Emp_ID and updating to the > particular record, every 20 mins data has to be updated for each Emp_ID, > for e.g : suppose for one Emp_ID data has updated on 2012-07-19 10:10:00 > then again it has to update on 2012-07-19 10:30:00 etc... > > and if data is not updated in 20 mins then one scheduler will verify > against the updated_on column value and inform user that data has not > updated for particular employee. > > Problem facing: > How to compare current datetime with updated_on coulmn value in web2py? > can anybody please share me the code to achieve the same? > --
