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