Take one field into your table as PostedDate or any Name <br /> and set its Default value getDate()<br /> it will automatically add exact date and time of you stored Data <br /> then at the time of retrieving just calculate that according to your Requirement.
postedDate
Datetime
getdate()
select datediff(d,postedDate ,getdate()) as DayOlder from tablename
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)