Sql datetime format in local and shared hosting

Question

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

Sachin Singh · Answer

use GetUTCDate() in sql stored procedure while saving record.

Nitin Sontakke · Answer

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 Kumawat · Answer

HI, Try using GetUTCDate() method for this.

Gajendra Jangid · Answer

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.

Muhammad Imran Ansari · Answer

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" ));