SQL Date format

[Simply Me]

I have DTPicker name as DTEntryDate and on form load I set it like this

  DTEntryDate.Value = Format$(Now, "mm/dd/yyyy") 'Display the Current Date

I used like this in my SQL INSERT

Format$(DTEntryDate.Value, "mm/dd/yyyy")

Why is it that when I look at the value saved in my table its like this 9/26/2007 12:00:00 AM? Its always 12:00:00 AM.
Questions:
1. Why is it that it is recorded as date and time wherein I specify "mm/dd/yyy" only?
2. How should I correct this to this play the current date and time? Or
3. How can omit the time part?