Working with CURRENT_TIMESTAMP

[eluser]codemonkey[/eluser]
Hello,

My web app uses CURRENT_TIMESTAMP to place a timestamp when something happens, say a new user was created and the timestamp was logged in the admin history table.

1. Is there a good resource on learning how to is this information to display a table to show all users created within the last week, for example, using active records and CI tables?

If no good resources, can you show how to do the example? Last 1 week entries from current date.

2. After doing some searching I found using CURRENT_TIMESTAMP may not of been the best option to use. If so, what should I use and how should I convert my current records to the new format?

I want to learn and use what is best for CI and if it helps me out in the long run, that's a bonus.

Thank you