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 4191 Oct 14, 2000, 2:49 PM
Thread Re: Default to current date
Bearwithme 4096 Oct 15, 2000, 6:42 AM
Post Re: Default to current date
Stealth 4115 Oct 16, 2000, 8:25 PM
Thread Re: Default to current date
donm 4062 Oct 28, 2000, 3:34 AM
Thread Re: Default to current date
Bearwithme 4065 Oct 28, 2000, 3:41 AM
Thread Re: Default to current date
santana 4034 Nov 21, 2000, 12:15 AM
Thread Re: Default to current date
Bearwithme 4030 Nov 21, 2000, 3:56 AM
Thread Re: Default to current date
santana 4044 Nov 21, 2000, 6:14 AM
Thread Re: Default to current date
Bearwithme 4016 Nov 21, 2000, 8:19 AM
Post Re: Default to current date
santana 4015 Nov 21, 2000, 9:34 PM