Hello,

How do I get a column defined as a type 'DATE' to default to the current date just like in dbman so that whenever I add a record the Date field defaults to today's date. Keep in mind this is within the context of using the db.cfg and nph-setup.cgi that comes with dbsql.

In my cfg file I've tried now(), curdate(), etc. for the default value for field Date but none of these have worked for me. Any insights or suggestions would be most appreciated.


easy does it