Re: using NOW() as a default..

"bruce" <[EMAIL PROTECTED]> wrote on 05/08/2004 06:12:58: > hi... > > a simple question... > > i'm creating a table and want to set a column to have the default of the > current day/time when the row is created... > > i've tried... > > create table foo( > dog int, > timestamp1 default NOW() >

using NOW() as a default..

hi... a simple question... i'm creating a table and want to set a column to have the default of the current day/time when the row is created... i've tried... create table foo( dog int, timestamp1 default NOW() ); with no success. i've also tried various iterations.. any ideas/solutions as to