By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,454 Members | 3,103 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,454 IT Pros & Developers. It's quick & easy.

Storing a C# data of data type timestamp into sql server table and then perform SUM

P: 44
I need to store a c# variable of data type timestamp into the SQL Server 2005 database. An example of how the variable value looks is as follows,

00:00:01.5000000

It represents the hours:mins:seconds

Once i store a series of these values into the sql table, then i need to make a SUM of all these values. What would be the best datatype to use for this value. Please help me in this regard.
May 9 '08 #1
Share this Question
Share on Google+
1 Reply


ck9663
Expert 2.5K+
P: 2,878
Until the guys come up with a better one, use varchar to store, then handle the conversion and calculation on retrieval.

-- CK
May 9 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.