Find out whether system time changed through Postrges
Posted on 2009-07-01
I have a record in postgres that stores time at which the record was created. The user can keep using the system, after 14 days my application should shutdown as the time has elapsed.
If the user resets the system time, can I find out through postgres whether the system time has been changed or whether the 14 days have been elapsed?
For eg, if the record was created on 1st July, the user keeps using the system till 12th July, but on the 13th he resets the system date to 5th July, can I still come to know whether the 12days have elapsed only through postgres?