I would like to have a field default of several tables in my database set to
the date portion of the getdate() function
I tried convert(getdate(),1) but I get a syntax error. I am using datetime
for the field type.
I am also using SQL Server 7.0 Desktop.