List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:August 17 1999 1:55pm
Subject:Re: CurDate as DEFAULT Value
View as plain text  
On Tue, 1999-08-17 08:52:10 -0500, Aaron Abelard wrote:
> > Juergen Hoffmann writes:
> >  > how can I set up a table to have as a default value the current date?
[...]
> You can use the DATETIME field type and insert a NULL for that column,
> which will have it use the current DATETIME stamp.

You mean a TIMESTAMP field, don't you?

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
CurDate as DEFAULT ValueJuergen Hoffmann17 Aug
  • CurDate as DEFAULT Valuesinisa17 Aug
    • Re: CurDate as DEFAULT Valueaaron abelard17 Aug
      • Re: CurDate as DEFAULT ValueMartin Ramsch17 Aug
        • Re: CurDate as DEFAULT ValueJuergen Hoffmann17 Aug
          • Re: CurDate as DEFAULT Valueaaron abelard17 Aug
            • RE: CurDate as DEFAULT ValueJay Miller17 Aug
              • RE: CurDate as DEFAULT ValueUrb LeJeune17 Aug
                • Re: CurDate as DEFAULT Value(Chris Adams)17 Aug
              • Re: CurDate as DEFAULT Valueaaron abelard17 Aug
              • Re: CurDate as DEFAULT Value(Sean McKenna)17 Aug
                • Re: CurDate as DEFAULT ValueJuergen Hoffmann17 Aug
              • RE: CurDate as DEFAULT ValueMichael Widenius22 Aug
          • Re: CurDate as DEFAULT ValueMartin Ramsch17 Aug
        • Re: CurDate as DEFAULT Valueaaron abelard17 Aug