.NET had DataTime which took user's local time zone into account by default. So .NET introduced DateTimeOffset where you can specify time zone.

but by then, DateTime was used in a lot of places, for eg: and .NET Sql Server driver mapped datatime against DateTime (instead of DataTimeOffset)

yeah, .NET has these issues too. and I have not even gone into DateTime Culture!