List:General Discussion« Previous MessageNext Message »
From:Riaan Oberholzer Date:February 5 2004 11:38am
Subject:[Q] setting DATE field with default NOW value?
View as plain text  
In a table definition, how do I get a date field to be
assigned as DEFAULT the current date?

I tried:

dateField DATE DEFAULT CURDATE()

but that gives me syntax errors....

Help?


__________________________________
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html
Thread
[Q] setting DATE field with default NOW value?Riaan Oberholzer5 Feb
  • Re: [Q] setting DATE field with default NOW value?Martijn Tonies5 Feb
  • Re: [Q] setting DATE field with default NOW value?KKoTY5 Feb
  • Re: [Q] setting DATE field with default NOW value?Martijn Tonies5 Feb
    • Re: [Q] setting DATE field with default NOW value?Brent Baisley5 Feb