Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Default to current date

Quote Reply
Default to current date
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
Subject Author Views Date
Thread Default to current date Bearwithme 5778 Oct 14, 2000, 2:49 PM
Thread Re: Default to current date
Bearwithme 5645 Oct 15, 2000, 6:42 AM
Post Re: Default to current date
Stealth 5663 Oct 16, 2000, 8:25 PM
Thread Re: Default to current date
donm 5606 Oct 28, 2000, 3:34 AM
Thread Re: Default to current date
Bearwithme 5609 Oct 28, 2000, 3:41 AM
Thread Re: Default to current date
santana 5578 Nov 21, 2000, 12:15 AM
Thread Re: Default to current date
Bearwithme 5573 Nov 21, 2000, 3:56 AM
Thread Re: Default to current date
santana 5589 Nov 21, 2000, 6:14 AM
Thread Re: Default to current date
Bearwithme 5559 Nov 21, 2000, 8:19 AM
Post Re: Default to current date
santana 5558 Nov 21, 2000, 9:34 PM