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)

score 4 · Answer 1 · answered Mar 04 '10 at 21:57

4

Yes, it defaults to 12:00 AM.

As you could have seen with a simple test.

answered Mar 04 '10 at 21:57

Andomar

232,371
49
380
404

score 1 · Accepted Answer · answered Mar 04 '10 at 21:57

1

It defaults to 12:00 AM.

answered Mar 04 '10 at 21:57

cleek

874
8
15

score 1 · Answer 3 · answered Mar 04 '10 at 21:58

1

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

answered Mar 04 '10 at 21:58

Hassan Syed

20,075
11
87
171

Can you explain what issue in the original question your pseudo-SQL is designed to address? – David-W-Fenton Mar 05 '10 at 21:27
To quote Andomar "As you could have seen with a simple test." – Hassan Syed Mar 05 '10 at 22:15
Sorry, but I still don't get how your pseudo-SQL reveals that. And it's not technically an answer to the question. – David-W-Fenton Mar 06 '10 at 17:12
I'd rather not downvote a useful answer. At this point I can't see it as useful, so I wouldn't downvote it just because I don't get it. I only downvote when I know the answer is wrong or misleading. If I don't know for sure, I'll leave it alone. – David-W-Fenton Mar 07 '10 at 20:29

score 1 · Answer 4 · answered Mar 04 '10 at 21:58

1

You are correct. 12:00 AM

answered Mar 04 '10 at 21:58

Doug Stalter

733
4
11

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

4 Answers4