Sql datetime format in local and shared hosting

Sushant Torankar

hello,

I am saving datetime in sql as UserMaster u= Datetime.Now, where it saves date in IST format on local

But I got USA based shared sql hosting, when I am saving same date , it got saved in Mountain or Pacific timezone

So how can I save date in local IST timezone format to hosting.

So any way I can save date in local IST timezone

I am using MVC and SQL

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke4y ago
As several others have suggested, please use GetUTCDate() instead of GetDate().

This is important and also try to understand the implications. Tomorrow, it is quite possible that your server will move to some other country. You would never know.

Somewhere and I am not sure exactly where, there should be a piece of code which would add 330 mins, to datetime, which is India's offset (and it never changes) to GMT for the purpose of display.

Hope it helps.

To formally close the thread please accept one of the answers, may be except this one.
Kapil Singh Kumawat4y ago
HI,

Try using GetUTCDate() method for this.
Gajendra Jangid4y ago
Yes. You shpuld use GetUTCDate(). or if you are using getdate() then you should add or remove 5 hour in date..or you if days are daylingt then it should be 6.
Sachin Singh4y ago
use GetUTCDate() in sql stored procedure while saving record.
Muhammad Imran Ansari4y ago
Try the following code:
DateTime utcdate = DateTime.ParseExact("3/30/2022 04:30:00 PM", "M/dd/yyyy hh:mm:ss tt",CultureInfo.InvariantCulture);
var istdate = TimeZoneInfo.ConvertTimeFromUtc(utcdate, TimeZoneInfo.FindSystemTimeZoneById("India Standard Time"));