I have dateTimeAuth column in sql table of datatype datetime and its default value is (getdate()) which returns me current time if i run my project at offline mode. When i uploaded it to live server it stores current time of default timezone GMT. I want value to be stored according to IST. How can it be done ?I have dateTimeAuth column in sql table of data