10 Replies Latest reply on Mar 18, 2008 9:42 AM by Dan Bracuk

    SQL Server 2000 database GETDATE() default for field

    ssailer Level 1
      I have a SQL Server 2000 database where the createDate field has a default value of GETDATE() and the data type is datetime. It is inserting the date just fine, but I do not want to capture the time along with the date. I only want the date to be entered. How can I accomplish this? Thanks!