List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:August 17 1999 3:16pm
Subject:Re: CurDate as DEFAULT Value
View as plain text  
On Tue, 1999-08-17 16:09:41 +0200, Juergen Hoffmann wrote:
> > You mean a TIMESTAMP field, don't you?
> 
> No,
> 
> i mean a field in which the current date is entered by default, so you can
> seee when this record was initially entered and not last modified... ;-)

Choices I see:

- TIMESTAMP: always update it with its old value, effectively leaving
             it unchanged (beside for the first time, where you put
             NULL in it)

- DATETIME:  manually insert NOW(), when first inserting a record

I guess, the latter is the easier way.

Regards,
  Martin

PS: My question above actually was directed to Aaron ... :)
-- 
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