CODEWITHSUNDEEP
sql-server-2008
Rajbir Singh
Rajbir Singh

Reputation: 1691

What should be the datatype for this type ("-07:00:00") of value in SQL Server 2008

Can anybody help me?

What should be the datatype for this type -07:00:00 of value in SQL Server 2008?

I have tried to search on the google but not get a proper answer.

Thanks

Upvotes: 1

Views: 37

Answers (2)

gbn
gbn

Reputation: 432271

int

This looks like a presentation problem, rather than a true datetime problem.
If so, I'd store this as -420 minutes or -25,200 seconds so it's more useful

Upvotes: 3

Oleg Dok
Oleg Dok

Reputation: 21766

  • [N][var]char(9)
  • in some circumstances - TIME (when somehow passed as positive value)

Upvotes: 1

Related Questions