in reply to NOW SQL portability
The NOW() function is not part of the ANSI SQL function standard.
Your best solution is to use perl to read the local OS date and time and store the result in your database. I use the Date::Calc Today_and_Now function. This works for basic inserts, but you would need to use the function you described above if you are using a trigger to update your database.
In Section
Seekers of Perl Wisdom