I was not sure what forum to post this in, but it is SQL Server 2008 R2 we are using so I will here. I have written a program and is using the DB as a backend and I have included an activity tracking log which posts transaction details into a data table (I also have one for error tracking). In my code I use LINQ to SQL. One of the fields is ActivityDateTime and when I save the data to the SQL Table, the date is okay, but the time is 00:00:00 and I have verified through the code that this is NOT the time that is being sent. The time being sent is the actual time of the transaction. For debugging purposes, I also have it writing this data to a csv file and the time is being written there correctly.
The field is set up in DB as datetime. Am I missing something?
Thanks for the information