SQL Database storing entries in GMT Time
I am storing the events from a couple of servers in the SQL Database and the SQL Database stores the data in the GMT Time. I have checked the servers and all the servers are in the local time(+5:30). When I use the SQL Query to check the time, the entries are being stored in the GMT Time rather than the local time which is creating a lot of problems for me. For some strange reasons, some of the entries show the right local time as well. Kindly advice how to resolve this problem.
Thanks a lot in advance.