CODEWITHSUNDEEP
mysqloffsetgmtdatetimeoffset
Chintan
Chintan

Reputation: 21

How do i store GMT offset with the DATETIME in MySQL Server

I was using C# with MS SQL Server 2008

Now i want to migrate to MySQL server 5.5

But i dont know how to store the GMT offset value in what data type of the MySQL Server?

Please help me store C#'s datatype DateTimeOffset to MySQL server

Anybody please help me?

Thanks, Chintan

Upvotes: 2

Views: 804

Answers (1)

wallyk
wallyk

Reputation: 57784

It has to be stored as a separate field. In MySQL, and most databases, date+time is a stored as a single scalar value, a 32- or 64-bit integer, depending on the specific time datatype.

Either store it as the corresponding entry in mysql.timezone.Time_zone_id, or use your own timezone table.

Upvotes: 1

Related Questions