sqlserver + timespan column datatype

Posted on 2007-04-04
Medium Priority
Last Modified: 2012-08-13
I'm using sqlserver and I have
One Column in a Table   whose DataType  is Timespan

How can I retrieve  Timespan Column  Value  on the Form using VB.Net


Question by:sohrabus
1 Comment
LVL 18

Accepted Solution

Sham Haque earned 2000 total points
ID: 18849248

"SQL Server 2005 does not support timespan datatypes directly.

You can wrap the CLR timespan type using the SQL CLR functionality and provide a cast that accepts the string format..."

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question