Search code examples
sql-serverms-accessdatetimeadp

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)

Solution

  • It defaults to 12:00 AM.