CODEWITHSUNDEEP
asp.netsqlsql-servertimezonetimezone-offset
frenchie
frenchie

Reputation: 51917

datatype for storing timezones

I want to store timezones but not in the timezoneoffset datatype. Should I use a decimal or a float? Or something else? Timezones can be GMT -3.5 for NewFoundland or +5.5 for parts of India so int wouldn't work.

Upvotes: 1

Views: 356

Answers (1)

Bobby D
Bobby D

Reputation: 2159

Why not use a lookup table? It would look like this: 

create table TimeZone (
    id int identity primary key,
    name varchar(50),
    offset decimal(2,1)
)

With a foreign key reference from your main table.

Upvotes: 1

Related Questions