I have a datetime field in my table whose default value is set to getdate(). This works except that the seconds are always 00. If I run "SELECT getdate()" from a command line, it returns seconds, and even milliseconds. Is there a way to format the column in the table to record the seconds?

Please disregard this thread, my problem was in the form code, not in SQL Server.