Hi :)<BR><BR>I've got a date/time field in which I want to insert a default value of the current date without it inserting the time as well. At the moment I'm using getdate() but this shows the time in which therecordwas added.<BR><BR>So I've got 2 questions:<BR><BR>1. How can I solve this?<BR><BR>2. Can someone point me in the direction of an SQL Server 2000 beginners site? I've found lots of SQL Server sites, but none seem to be heavily geared towards the beginner.<BR><BR>Thanks in advance,<BR><BR>hellz.