List:General Discussion« Previous MessageNext Message »
From:Fred Read Date:May 5 1999 9:09am
Subject:Re: Default = Now()
View as plain text  
Jay Miller wrote:
> 
> A timestamp will not work here because I only want it 
> set to the current time on INSERT, not on UPDATE.

But you could make it work by ensuring you always have 
"set Created = Created" in the update. A bit of a pain 
but it would do what you want!
-- 

If it ain't opinionated, it ain't Rich Teer.
Thread
Default = Now()Jay Miller4 May
RE: Default = Now()Jay Miller4 May
  • Re: Default = Now()Fred Read5 May