I have some SQL that works fine on mysql but which uses the "NOW()" function. However this does not work on SQLite because by default that has no "NOW()" function. The DBD::SQLite man page describes how you can add a NOW function, but that only fixes SQLite not the general portability problem. Looking at perlport scares me even more. The definition of epoch varies from OS to OS so you cannot even rely on the time function. So the question is what is the most portable and lightweight SQL compatible way of generating today's date?