What is the time of a datetime field in a database if only the date is entered?

I am working on an Access adp that has its data stored in sql-server. I have a sql statement that inserts the date part of a dateTime object into a datetime field of a table.

INSERT INTO...DateValue(myDateTimeVariable) 开发者_开发百科

What is the time defaulted to?

(I am hoping that it defaults to 12:00 AM)

Yes, it defaults to 12:00 AM.

As you could have seen with a simple test.

It defaults to 12:00 AM.

select * from [table where you inserted to] 
where key = [key you used to inserted to]

You are correct. 12:00 AM