CODEWITHSUNDEEP
sqlsql-serverentity-framework
Evan
Evan

Reputation: 856

Which Sql Server column type to use for a position in a video?

So I want to store a value that represents something like "10 minutes and 35 seconds into the video". I was going to use the type time, but my value could be greater than 24 hours. My data would probably always be formatted hours:minutes:seconds.

Also, I'm using Entity Framework so I need some type that will translate well. Thanks.

Upvotes: 2

Views: 74

Answers (2)

CruelCoin
CruelCoin

Reputation: 3

I'd use a VARCHAR and do some formatting as you read the values out.

Upvotes: 0

turtlepick
turtlepick

Reputation: 2714

When I have questions like this I try to find "what are the pros doing?"

If you go to YouTube and share the video at current time you'll see they add a Query Parameter t=10 (10 seconds into the video).

So I would use int .

Upvotes: 7

Related Questions