I have a field with a datatype of datetime called test. The value I'm trying to insert is 07/21/2006. The insert statement executes without error, however, the value that is entered into the DB is not correct. This is the value that gets entered: 1900-01-02 00:00:00.000. Below is my insert statement. Any clue what I'm doing wrong?
insert into tbl_Journal(fgn_folioRecId, txtActivity, txtNote, fgn_userRecId, bitFollowUp, test, intCreatedBy)
values(66, 'Comment to county', 'sdf sdfa fds daf', 24, 07/21/2006, 1, 24)