Insert time data into SQL Server with C#

Question

I would like to know how to insert TIME into SQL Server using C#

I have a class that I use as a data layer:

    public class Main_Lom_Form
    {
        public string Specimen_ID
        public int Client_Key
        public string Outcome
        public string Medications
        public DateTime Date_Collected
        public DateTime Time_Collected

and I do not know if I should be declaring Time_Collected as DateTime?

What type should Time_Collected be so that if the time would be 13:05 it would be entered correctly into a column in SQL Server 2008 that is a TIME(7) datatype?

You can use a datetime to store it, you can use Date_Collected.TimeOfDay.ToString() and SQL-Server will parse it to the correct TIME(7) datatype. msdn.microsoft.com/en-us/library/bb677243.aspx — Tim Schmelter
– Tim Schmelter, Commented Dec 22, 2011 at 20:17

Dennis Traub · Accepted Answer · 2011-12-22 20:29:35Z

6

TimeSpan maps to time(7)
DateTime maps to datetime

If you only want to store time, then time(7) should be okay. Is there a reason why you don't combine Date_Collected and Time_Collected into one field of type datetime?

edited Dec 22, 2011 at 20:29

answered Dec 22, 2011 at 20:18

Dennis Traub

51.9k7 gold badges100 silver badges113 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Alex Gordon Over a year ago

in that case which datatype on sql server should i choose?

Dennis Traub Over a year ago

(Edited my comment into answer above.)

Collectives™ on Stack Overflow

Insert time data into SQL Server with C#

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related