What is the best way to represent a timespan in SQL Server CE?

sql-server-ce timespan
Davy8 picture Davy8 · Apr 5, 2009 · Viewed 13.8k times · Source

Specifically speaking I only need hours:minutes but say I have a .NET TimeSpan object, how should I store that in a SQL(CE) database?

Answer

Bob King picture Bob King · Apr 13, 2009

I'd recommend using a long to represent the number of ticks. That's what TimeSpan uses as it's internal representation. This lets you easily reconstitute your object with the Timespan.FromTicks() method, and output to the database using the Timespan.Ticks property. The smallest unit of time in .NET is the tick, which is equal to 100 nanoseconds

Related questions

How do you open an SDF file (SQL Server Compact Edition)?

I have an SDF file and I would like to retrieve its schema and query it with some UI. How can I do this? I have no Visual Studio installed on the machine and I would like to install as …

Read More
How to connect to SQL Server from another computer?

I want to connect from home using SQL Server 2005 to another PC. I had a look on the msd...but before connecting it says I should connect to another computer using the computer management and it didn't work out....I …

Read More
Creating stored procedure with declare and set variables

I am creating one stored procedure where only value has to pass and I have to retrieve multiple values from multiple tables. I tried to do like this but its showing errors like Incorrect Syntax near Begin and Must declare …

Read More