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() ); Defaults can

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