Time in inserts/updates should be controlled in code. This will allow for more flexibility and easier testing than delegating that job to the database with invariable query strings.