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

Question

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)

Answer 1

It defaults to 12:00 AM.

Answer 2

Yes, it defaults to 12:00 AM.

As you could have seen with a simple test.

Answer 3

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

Answer 4

You are correct. 12:00 AM