List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:December 23 1999 5:01pm
Subject:Re: datetime
View as plain text  
At 10:08 AM -0500 1999-12-23, <repett0@stripped> wrote:
>I have a field in a table that is type datetime.  I was wondering how come
>it wont get set to the default(current) time if I don't put a value in it.
>That is if I use the web form.  If I insert in mysql (not doing anyting to
>it) it works?

For a DATETIME type, you can't.  Default values must be constants.
You could use a TIMESTAMP instead.

Paul DuBois, paul@stripped
datetimerepett023 Dec
  • Re: datetimesinisa23 Dec
  • Re: datetimePaul DuBois23 Dec
  • Re: datetimeMatthew Vanecek23 Dec
    • Re: datetimePaul DuBois23 Dec