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).