List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:May 26 2003 5:32am
Subject:Re: DEFAULT value for DATETIME field
View as plain text  
In the last episode (May 26), Venkata Srinivasa Rao, Yerra said:
> Dear Nelson,
> 
>         TIMESTAMP type field data will be modified whenever the record get 
> updates.
>         I don't want lose the original date & time because I want to keep 
> record create date & time.

Ah. Then you'll have to either insert NOW() into that field when you create
the record, or create two TIMESTAMP fields.  Both will be updated on
insert, but only the first will be updated when the record is modified.

-- 
	Dan Nelson
	dnelson@stripped
Thread
sql error help?trogers25 May
  • Re: sql error help?Joseph Bueno25 May
  • SQL and WAP? (newbie)2Hosts.com25 May
    • RE: SQL and WAP? (newbie)Michael S. Fischer25 May
      • Re: SQL and WAP? (newbie)2Hosts.com26 May
        • DEFAULT value for DATETIME fieldYerra Venkata Srinivasa Rao26 May
          • Re: DEFAULT value for DATETIME fieldDan Nelson26 May
            • Re: DEFAULT value for DATETIME fieldYerra Venkata Srinivasa Rao26 May
              • Re: DEFAULT value for DATETIME fieldDan Nelson26 May
          • Re: DEFAULT value for DATETIME fieldJames Moe26 May
    • need favour ;)n0n4m326 May