Yes I know this. However my question was what is the most lightweight and portable way of getting today's date in an SQL compatible manner? Also the suggested code in DBD::SQLite uses "time" directly.
portable way of getting today's date in an SQL compatible manner?
Not sure if there is a portable way of getting a timestamp in SQL (such as MySQL's NOW()). AFAIK, there's not even a 100% portable way of telling a DB to store one... (for example, see this for a quick comparison).