--- a/hooks/syncschema.py	Tue Nov 22 11:26:06 2011 +0100
+++ b/hooks/syncschema.py	Mon Nov 21 17:58:18 2011 +0100
@@ -484,6 +484,11 @@
         # set default value, using sql for performance and to avoid
         # modification_date update
         if default:
+            if  rdefdef.object in ('Date', 'Datetime'):
+                if default == 'TODAY':
+                    default = syssource.dbhelper.sql_current_date()
+                elif default == 'NOW':
+                    default = syssource.dbhelper.sql_current_timestamp()
             session.system_sql('UPDATE %s SET %s=%%(default)s' % (table, column),
                                {'default': default})